DBA Data[Home] [Help]

VIEW: SYS.GV_$STANDBY_LOG

Source

View Text - Preformatted

select "INST_ID","GROUP#","DBID","THREAD#","SEQUENCE#","BYTES","BLOCKSIZE","USED","ARCHIVED","STATUS","FIRST_CHANGE#","FIRST_TIME","NEXT_CHANGE#","NEXT_TIME","LAST_CHANGE#","LAST_TIME","CON_ID" from gv$standby_log
View Text - HTML Formatted

SELECT "INST_ID"
, "GROUP#"
, "DBID"
, "THREAD#"
, "SEQUENCE#"
, "BYTES"
, "BLOCKSIZE"
, "USED"
, "ARCHIVED"
, "STATUS"
, "FIRST_CHANGE#"
, "FIRST_TIME"
, "NEXT_CHANGE#"
, "NEXT_TIME"
, "LAST_CHANGE#"
, "LAST_TIME"
, "CON_ID"
FROM GV$STANDBY_LOG