V$CONTROLFILE definition in Oracle Database 11.2
V$CONTROLFILE

select
  STATUS,                                  -- STATUS VARCHAR2(7)
  NAME,                                    -- NAME VARCHAR2(513)
  IS_RECOVERY_DEST_FILE,                   -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
  BLOCK_SIZE,                              -- BLOCK_SIZE NUMBER
  FILE_SIZE_BLKS                           -- FILE_SIZE_BLKS NUMBER
from
  GV$CONTROLFILE
where
  inst_id = USERENV('Instance')

home |  up