V$LOGSTDBY_TRANSACTION

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)`	ACTIVE: This transaction is still being mined by LogMiner. At least part of this transaction is ready to be applied or has already been applied. COMPLETE: This transaction is complete and ready to be applied. LogMiner has finished mining.
`APPLY_STATUS`	`VARCHAR2(6)`	ACTIVE: This transaction has been assigned to an apply server. It is in one of the following states: - The transaction is being actively applied - The transaction is being held by an apply server waiting for certain events to occur - The transaction is being held by an apply server waiting for subsequent parts of this transaction NONE: This transaction has not yet been assigned to an apply server
`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.