V$LOGSTDBY_TRANSACTION
displays all active transactions in the Logical Standby pipeline.
Column | Datatype | Description |
---|---|---|
PRIMARY_XID |
RAW(8) |
The transaction ID |
PRIMARY_START_SCN |
NUMBER |
Start system change number (SCN) base |
PRIMARY_START_TIME |
DATE |
Start time |
PRIMARY_PARENT_XID |
RAW(8) |
Transaction ID of the parent transaction (PDML) |
MINING_STATUS |
VARCHAR2(32) |
|
APPLY_STATUS |
VARCHAR2(6) |
|
SID |
NUMBER |
Session ID of the apply server's session. Null if APPLY_STATUS is NONE. |
SERIAL# |
NUMBER |
Serial number of the apply server's session. Null if APPLY_STATUS is NONE. |