DBA Data[Home] [Help]

VIEW: SYS.DBA_LOGSTDBY_EVENTS

Source

View Text - Preformatted

select cast(event_time as date) event_time, event_time event_timestamp,
         spare1 as start_scn, current_scn, commit_scn, xidusn, xidslt, xidsqn,
         full_event event, errval status_code, error status,
         con_name src_con_name, con_id src_con_id
  from system.logstdby$events
View Text - HTML Formatted

SELECT CAST(EVENT_TIME AS DATE) EVENT_TIME
, EVENT_TIME EVENT_TIMESTAMP
, SPARE1 AS START_SCN
, CURRENT_SCN
, COMMIT_SCN
, XIDUSN
, XIDSLT
, XIDSQN
, FULL_EVENT EVENT
, ERRVAL STATUS_CODE
, ERROR STATUS
, CON_NAME SRC_CON_NAME
, CON_ID SRC_CON_ID
FROM SYSTEM.LOGSTDBY$EVENTS