 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 7 -
Monitoring and Troubleshooting Oracle Streams
v$propagation_receiver
This view displays information about buffer
queue propagation schedules on the receiving side. The columns
SRC_QUEUE_NAME and SRC_DBNAME show the Capture process name and
source database name, respectively.
The following SQL query shows details:
select SRC_QUEUE_NAME, SRC_DBNAME ,
HIGH_WATER_MARK, ACKNOWLEDGEMENT,
ELAPSED_ENQUEUE_TIME from
v$propagation_receiver
/
v$propagation_sender
This view displays information about buffer
queue propagation schedules on the sending side. At the source side,
execute this SQL to show details:
select QUEUE_NAME, SCHEDULE_STATUS,
HIGH_WATER_MARK, TOTAL_BYTES, TOTAL_MSGS from v$propagation_sender
;
v$queue
This view contains information on the shared
server message queues. It shows the number of items in the queue and
how many waited, etc.
dba_propagation
This view displays information about the
Streams propagations in the database. The source queue and
destination queue for each of the propagations can be determined by
querying this view as shown in the SQL statement below:
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
|
|
