V$INSTANCE_LOG_GROUP definition in Oracle Database 11.2
V$INSTANCE_LOG_GROUP

select
  THREAD#,                                 -- THREAD# NUMBER
  STATUS,                                  -- STATUS VARCHAR2(6)
  ENABLED,                                 -- ENABLED VARCHAR2(8)
  GROUPS,                                  -- GROUPS NUMBER
  INSTANCE,                                -- INSTANCE VARCHAR2(80)
  OPEN_TIME,                               -- OPEN_TIME DATE
  CURRENT_GROUP#,                          -- CURRENT_GROUP# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  CHECKPOINT_CHANGE#,                      -- CHECKPOINT_CHANGE# NUMBER
  CHECKPOINT_TIME,                         -- CHECKPOINT_TIME DATE
  ENABLE_CHANGE#,                          -- ENABLE_CHANGE# NUMBER
  ENABLE_TIME,                             -- ENABLE_TIME DATE
  DISABLE_CHANGE#,                         -- DISABLE_CHANGE# NUMBER
  DISABLE_TIME                             -- DISABLE_TIME DATE
from
  GV$INSTANCE_LOG_GROUP
where
  inst_id = USERENV('Instance')

home |  up