DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_LOGSTDBY_EVENTS

Object Details
Object Name: DBA_LOGSTDBY_EVENTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information on why logical standby events

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_TIME DATE

Time the event took place
EVENT_TIMESTAMP TIMESTAMP(6) (11) Yes Timestamp when the event took place
START_SCN NUMBER

SCN at which the transaction started
CURRENT_SCN NUMBER

Change vector SCN for the change
COMMIT_SCN NUMBER

SCN for the commit record of the transaction
XIDUSN NUMBER

Transaction id, part 1 of 3
XIDSLT NUMBER

Transaction id, part 2 of 3
XIDSQN NUMBER

Transaction id, part 3 of 3
EVENT CLOB (4000)
A SQL statement or other text describing the event
STATUS_CODE NUMBER

A number describing the event
STATUS VARCHAR2 (2000)
A text string describing the event
SRC_CON_NAME VARCHAR2 (30)
Source container name
SRC_CON_ID NUMBER

Source container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_TIME
,      EVENT_TIMESTAMP
,      START_SCN
,      CURRENT_SCN
,      COMMIT_SCN
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      EVENT
,      STATUS_CODE
,      STATUS
,      SRC_CON_NAME
,      SRC_CON_ID
FROM SYS.DBA_LOGSTDBY_EVENTS;

Dependencies

[top of page]

SYS.DBA_LOGSTDBY_EVENTS references the following:

SchemaSYSTEM
TableLOGSTDBY$EVENTS
SYS.DBA_LOGSTDBY_EVENTS is referenced by following:

SchemaPUBLIC
SynonymDBA_LOGSTDBY_EVENTS