 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 5 -
Apply Process Configuration
Coordinator Process:
The state of a coordinator process describes
what the coordinator process is doing currently. The state of a
coordinator process can be viewed by querying the
v$streams_apply_coordinator dynamic performance view. The
following coordinator process states are possible:
-
INITIALIZING - Starting up
-
APPLYING - Passing transactions to Apply
servers
-
SHUTTING DOWN CLEANLY - Stopping without an
error
-
ABORTING - Stopping because of an Apply error
The following SQL block, for example, shows the
activity of the Apply coordinator:
COL APPLY_NAME HEADING 'Apply Process Name'
FORMAT A25
COL TOTAL_RECEIVED HEADING
'Total|Trans|Received' FORMAT 99999999
COL TOTAL_APPLIED HEADING 'Total|Trans|Applied'
FORMAT 99999999
COL TOTAL_ERRORS HEADING 'Total|Apply|Errors'
FORMAT 9999
COL BEING_APPLIED HEADING 'Total|Trans
Being|Applied' FORMAT 9999999
COL TOTAL_IGNORED HEADING 'Total|Trans|Ignored'
FORMAT 99999999
--
SELECT APPLY_NAME,
TOTAL_RECEIVED,
TOTAL_APPLIED,
TOTAL_ERRORS,
TOTAL_ASSIGNED - (TOTAL_ROLLBACKS +
TOTAL_APPLIED) BEING_APPLIED,
TOTAL_IGNORED
FROM V$STREAMS_APPLY_COORDINATOR
/
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
|
|
