v$streams_apply_coordinator
-
total_received – The total number of
transactions received by the coordinator process since the Apply
process was last started.
-
hwm_message_number – The number of
the message corresponding to the high watermark. In other words,
it shows the highest message number that has been applied.
-
hwm_message_create_time – The
creation time at the source database of the message
corresponding to the high watermark.
-
startup_time – The time when the
Apply process was last started.
The following SQL statement shows the basic
details of the coordinator process:
COLUMN APPLY_NAME HEADING 'Apply
Process|Name' FORMAT A25
COLUMN PROCESS_NAME HEADING 'Coordinator|Process|Name'
FORMAT A11
COLUMN SID HEADING 'Session|ID' FORMAT 9999
COLUMN SERIAL# HEADING 'Session|Serial|Number'
FORMAT 999999
COLUMN STATE HEADING 'State' FORMAT A21
