||Oracle Tips by Burleson
Chapter 5 -
Apply Process Configuration
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
SHUTTING DOWN CLEANLY - Stopping without an
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'
COL TOTAL_RECEIVED HEADING
'Total|Trans|Received' FORMAT 99999999
COL TOTAL_APPLIED HEADING 'Total|Trans|Applied'
COL TOTAL_ERRORS HEADING 'Total|Apply|Errors'
COL BEING_APPLIED HEADING 'Total|Trans
Being|Applied' FORMAT 9999999
COL TOTAL_IGNORED HEADING 'Total|Trans|Ignored'
TOTAL_ASSIGNED - (TOTAL_ROLLBACKS +
The above text is
an excerpt from:
High Speed Replication and Data
by Madhu Tumma
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA