select
  TYPE,                                    -- TYPE VARCHAR2(28)
  RECORD_SIZE,                             -- RECORD_SIZE NUMBER
  RECORDS_TOTAL,                           -- RECORDS_TOTAL NUMBER
  RECORDS_USED,                            -- RECORDS_USED NUMBER
  FIRST_INDEX,                             -- FIRST_INDEX NUMBER
  LAST_INDEX,                              -- LAST_INDEX NUMBER
  LAST_RECID                               -- LAST_RECID NUMBER
from
  GV$CONTROLFILE_RECORD_SECTION
where
  inst_id = USERENV('Instance')