Oracle Streams Monitoring Troubleshooting Oracle Streams v$rule_set_aggregate_stats dba_evaluation_context_tables dba_evaluation_context_vars dba_evaluation_contexts dba_rule_set_rules dba_rule

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

rule set user function calls (variable value function) – This is the total number of calls made to user-defined functions to retrieve variable values, specified by the variable_value_function field in re$variable_type, made during evaluations on rule sets.
rule set user function calls (variable method function) – This is the total number of calls made to user-defined functions to retrieve variable method values, specified by the variable_method_function field in re$variable_type, made during evaluations on rule sets.
rule set user function calls (evaluation function) –This is the total number of calls made to user-defined evaluation functions, specified as the evaluation_function argument to the create_evaluation_context procedure, made during evaluations on rule sets.

dba_evaluation_context_tables

This view describes the tables in the rule evaluation contexts.

dba_evaluation_context_vars

This view describes the variables in the rule evaluation contexts.

dba_evaluation_contexts

This view describes the rule evaluation contexts in the database.

dba_rule_set_rules

This view describes the rules in the rule sets.

dba_rule_sets

This view describes all the rule sets in the database. The following SQL query displays the rule_set names and the default evaluation context for each rule set in a database:

The above text is an excerpt from:

Oracle Streams
High Speed Replication and Data Sharing

ISBN 0-9745993-5-2

by Madhu Tumma

http://www.rampant-books.com/book_2004_2_streams.htm

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 10g reference poster

Oracle training & performance tuning books