 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 7 -
Monitoring and Troubleshooting Oracle Streams
dba_rules
SELECT RULE_OWNER, RULE_NAME FROM DBA_RULES
SEE
CODE DEPOT FOR FULL SCRIPT
/
In order to understand the current rule
condition or to make any changes, this view would be a useful tool.
dba_streams_global_rules
This view displays information about the global
rules.
This view only contains information about rules
created using the add_global_propagation or
add_global_rules procedures in the dbms_streams_adm
package. It does not contain information about rules created using
the dbms_rule_adm package.
dba_streams_message_consumer
This view displays information about the
Streams messaging clients in the database.
dba_streams_message_rules
This view displays information about the
Streams messaging rules in the database.
dba_streams_rules
This view displays information about the rules
used by all the Streams processes in the database. This has more
columns and comprehensive details than the dba_rules view.
The following SQL query shows all the rules and rules sets for all
the Streams clients:
COLUMN STREAMS_NAME HEAD 'Streams|Name'
FORMAT A14
COLUMN STREAMS_TYPE HEAD 'Streams|Type'
FORMAT A11
COLUMN RULE_NAME HEAD
'Rule|Name' FORMAT A12
COLUMN RULE_SET_TYPE HEAD 'Rule Set|Type'
FORMAT A8
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. |
|
