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')