> 文章列表 / Page 332

2006-04-19

Setting an Oracle event:The structure of the trace syntax

PURPOSE ------- The purpose of this article is to explain briefly the structure of the syntax to event-based trace generation.…

#POST 4 MIN READ

2006-02-26

Script to Collect RAC Diagnostic Information (racdiag.sql)

Script: -- NAME: RACDIAG.SQL -- SYS OR INTERNAL USER, CATPARR.SQL ALREADY RUN, PARALLEL QUERY OPTION ON -- ------------------------------------------------------------------------ -- AUTHOR:…

#POST 21 MIN READ

2005-08-24

Know Oracle Date And Time Function

Oracle9i provides extended date and time support across different time zones with the help of new datetime data types and…

#POST 16 MIN READ

2005-07-10

Rollback Segment Utilization:Extent, Wrap and Shrink

This practice will demonstrate the  concept of extent, wrap and shrink in rollback segment utilization. You will: Use the create…

#POST 9 MIN READ

2005-07-10

Know about Oracle Network Security

Good network security is accomplished by utilizing port and protocol screening with routers, firewalls, and Intrusion Detection Systems.Port and protocol…

#POST 12 MIN READ

2005-07-10

Practice:Demonstrating Oracle AUDIT Concepts and Procedures

This practice uses common UNIX and NT Oracle utilities to practice enabling AUDIT on a database.  You will: See the…

#POST 3 MIN READ

2005-07-10

Practice:Demonstrating Database User Objects, Roles and Permissions

This practice uses common UNIX and Windows NT Oracle utilities to review database user objects’ key roles and  permissions.  You…

#POST 4 MIN READ

2005-07-10

Practice:Demonstrating the Key TCP/IP Protocols

This practice uses common UNIX and Windows NT utilities to visualize key TCP/IP protocols.  You will: See IP information using…

#POST 3 MIN READ

2005-07-07

Script: Computing Table Size

This script calculates the average row size for all tables in a schema. It generates a script (getAvgCol.sql) from USER_TABLES…

#POST 2 MIN READ

2005-01-11

Data Block Cache Header Format Changes (Oracle8 Physical layout)

Oracle8 has introduced a change with the data block cache header format. The basic idea is that incarnation and sequence…

#POST 3 MIN READ