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

The names of the statistics are as follows:

  • rule set evaluations (first_hit) – This is the total number of evaluations on rule sets with stop_on_first_hit set to TRUE.
     

  • rule set evaluations (simple_rules_only) – This is the total number of evaluations on rule sets with simple_rules_only set to TRUE.
     

  • rule set evaluations (SQL free) – This is the total number of evaluations on rule sets which did not internally issue SQL to evaluate rules.
     

  • rule set evaluation time (CPU) – This is the total CPU time, in hundredths of a second, spent in evaluations on rule sets.
     

  • rule set evaluation time (elapsed) – This is the total elapsed time, in hundredths of a second, spent in evaluations on rule sets.
     

  • rule set SQL executions – This is the total number of SQL statements executed during evaluations on rule sets.
     

  • rule set conditions processed – This is the total number of fast indexed conditions processed during evaluations on rule sets.
     

  • rule set true rules – This is the total number of TRUE rules returned during evaluations on rule sets.
     

  • rule set maybe rules – This is the total number of MAYBE rules returned during evaluations on rule sets.


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: