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
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
|
|
|