 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 7 -
Monitoring and Troubleshooting Oracle Streams
dba_queues
COLUMN OWNER HEADING 'Owner' FORMAT A10
COLUMN NAME HEADING 'Queue Name' FORMAT A28
COLUMN QUEUE_TABLE HEADING 'Queue Table' FORMAT
A22
COLUMN USER_COMMENT HEADING 'Comment' FORMAT
A15
SELECT q.OWNER, q.NAME, t.QUEUE_TABLE,
q.USER_COMMENT
FROM DBA_QUEUES q, DBA_QUEUE_TABLES t
SEE CODE DEPOT FOR FULL SCRIPT
In Streams, the majority of queues are
sys.anydata queues.
dba_queue_tables
This view describes the queues in the queue
tables in the database. It shows some useful information such as the
primary and secondary affinity specifications and recipient details.
dba_queue_schedules
This view describes the current schedules for
propagating messages. It shows the QNAME, which is source queue
name, and DESTINATION, which is the destination name. This is
currently limited to being a DBLINK name.
The above text is
an excerpt from:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
