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.