DBA Data[Home] [Help]

VIEW: SYS.V_$INSTANCE_LOG_GROUP

Source

View Text - Preformatted

select "THREAD#","STATUS","ENABLED","GROUPS","INSTANCE","OPEN_TIME","CURRENT_GROUP#","SEQUENCE#","CHECKPOINT_CHANGE#","CHECKPOINT_TIME","ENABLE_CHANGE#","ENABLE_TIME","DISABLE_CHANGE#","DISABLE_TIME","CON_ID" from v$instance_log_group
View Text - HTML Formatted

SELECT "THREAD#"
, "STATUS"
, "ENABLED"
, "GROUPS"
, "INSTANCE"
, "OPEN_TIME"
, "CURRENT_GROUP#"
, "SEQUENCE#"
, "CHECKPOINT_CHANGE#"
, "CHECKPOINT_TIME"
, "ENABLE_CHANGE#"
, "ENABLE_TIME"
, "DISABLE_CHANGE#"
, "DISABLE_TIME"
, "CON_ID"
FROM V$INSTANCE_LOG_GROUP