 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 7 -
Monitoring and Troubleshooting Oracle Streams
v$rule_set
SELECT OWNER, NAME, EVALUATIONS, SQL_EXECUTIONS,
SQL_FREE_EVALUATIONS, TRUE_RULES, MAYBE_RULES
FROM V$RULE_SET
/
The SQL statement shown below has the following
information about each rule set in a database:
-
The total number of seconds of CPU time used to
evaluate the rule set since the database instance last started.
-
The total number of seconds used to evaluate
the rule set since the database instance last started.
-
The total number of shared memory bytes used to
evaluate the rule set since the database instance last started.
COLUMN OWNER HEAD 'Rule
Set|Owner' FORMAT A15
COLUMN NAME HEAD 'Rule
Set Name' FORMAT A15
COLUMN CPU_SECONDS HEAD 'Seconds|of
CPU|Time' FORMAT 999999.999
COLUMN ELAPSED_SECONDS HEAD 'Seconds
of|Eval|Time' FORMAT 999999.999
COLUMN SHARABLE_MEM HEADING 'Bytes|of
Shared|Memory' FORMAT 999999999
SELECT OWNER,NAME,
(CPU_TIME/100) CPU_SECONDS,
(ELAPSED_TIME/100) ELAPSED_SECONDS,
SHARABLE_MEM
FROM V$RULE_SET
/
The CPU and memory byte stats help the DBA
understand the rule processing activity.
The above text is
an excerpt from:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
