V$LOGFILE definition in Oracle Database 11.2

V$LOGFILE

select
  GROUP#,                                  -- GROUP# NUMBER
  STATUS,                                  -- STATUS VARCHAR2(7)
  TYPE,                                    -- TYPE VARCHAR2(7)
  MEMBER,                                  -- MEMBER VARCHAR2(513)
  IS_RECOVERY_DEST_FILE                    -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
from
  GV$LOGFILE
where
  inst_id = USERENV('Instance')

home | up