Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


DBA_LOGSTDBY_EVENTS displays information about the activity of the logical standby database system. It can be used to determine the cause of failures that occur when applying redo data to logical standby databases. This view is for logical standby databases only.

Column Datatype NULL Description
EVENT_TIME DATE   Time when the event was logged
EVENT_TIMESTAMP TIMESTAMP(6) NOT NULL Timestamp when the event was logged
START_SCN NUMBER   The SCN at which the associated transaction started at the primary database. This SCN refers to the system change number at the primary database.
CURRENT_SCN NUMBER   SCN associated with the change at the primary database. If a failure occurred, then examine this column to determine which archived log file contains the source of the failure (for example, an unsupported record).
COMMIT_SCN NUMBER   SCN value on which the change was committed at the primary database
XIDUSN NUMBER   Transaction ID undo segment number at the primary database of the associated transaction
XIDSLT NUMBER   Transaction ID slot number at the primary database of the associated transaction
XIDSQN NUMBER   Transaction ID sequence number at the primary database of the associated transaction
EVENT CLOB   Statement that was being processed when the failure occurred
STATUS_CODE NUMBER   Status (or Oracle error code) belonging to the STATUS message
STATUS VARCHAR2(2000)   Description of the current activity of the process or the reason why the apply operation stopped
SRC_CON_NAME VARCHAR2(30)   Identifies the PDB name at the primary database where the transaction was executed


In a CDB, this view shows data only when queried in the root.