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 the event was logged | |
EVENT_TIMESTAMP |
TIMESTAMP(6) |
Timestamp when the event was logged | |
CURRENT_SCN |
NUMBER |
Change vector SCN for the change. 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 | |
XIDUSN |
NUMBER |
Transaction ID undo segment number | |
XIDSLT |
NUMBER |
Transaction ID slot number | |
XIDSQN |
NUMBER |
Transaction ID sequence number | |
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 |