 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 7 -
Monitoring and Troubleshooting Oracle Streams
dba_apply_progress
This view displays information about the
progress made by the Apply processes that dequeues events from
queues that are accessible to the current user. This view only
contains information about captured events. It does not contain
information about user-enqueued events. This is an important view
which keeps track of the applied messages.
Some useful columns include:
-
APPLIED_MESSAGE_NUMBER shows the message number
up to which all transactions have definitely been applied. This
represents the low watermark for the Apply process. It means the
messages with a commit message number less than or equal to this
message number have definitely been applied.
-
OLDEST_MESSAGE_NUMBER shows the earliest
message number of the transactions currently being dequeued and
applied. The difference between the apply_time and applied_message_create_time is the latency time.
The following SQL statement shows details of
the Apply progress:
COLUMN APPLY_NAME HEADING 'Apply Process|Name'
FORMAT A16
COLUMN 'Latency in Seconds'
FORMAT 999999999
COLUMN 'Event Creation'
FORMAT A18
COLUMN 'Apply Time'
FORMAT A18
COLUMN APPLIED_MESSAGE_NUMBER HEADING
'Applied|Message|Number' FORMAT 99999999
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
|
|
