For Oracle support & training call (800) 766-1884
Free Oracle Tips

Home
Oracle Tips
Oracle Code Depot
Oracle Monitoring
Oracle Consulting
Oracle Training
Oracle News
Oracle Forum
Oracle Support





 

Free Oracle Tips

image

 
HTML Text

Free Oracle App Server Tips

image

 
HTML Text


Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle


 

   
  Oracle Tips by Burleson

Oracle Streams
Chapter 7 -
Monitoring and Troubleshooting Oracle Streams

v$rule_set_aggregate_stats

This view displays statistics aggregated over all evaluations on all rule sets. This view has a row for each type of statistic.

COLUMN NAME HEADING 'Name of Statistic' FORMAT A55
COLUMN VALUE HEADING 'Value' FORMAT 999999999

SELECT NAME, VALUE FROM V$RULE_SET_AGGREGATE_STATS
/

Name of Statistic                                            Value
------------------------------------------------------- ----------
rule set evaluations (all)                                  204181
rule set evaluations (first_hit)                            204181
rule set evaluations (simple_rules_only)                      2907
rule set evaluations (SQL free)                               4478
rule set evaluation time (CPU)                              269203
rule set evaluation time (elapsed)                          282559
rule set SQL executions                                     199703
rule set conditions processed                               206341
rule set true rules                                         179511
rule set maybe rules                                          2848
rule set user function calls (variable value function)      199711
rule set user function calls (variable method function)    1014025
rule set user function calls (evaluation function)          202612

13 rows selected.


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.

  
 

 
 
 
 
Oracle performance tuning software
 
 

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544


Email BC: