Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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.