VIEW: SYS.GV_$CONTROLFILE

Source

View Text - Preformatted

select "INST_ID","STATUS","NAME","IS_RECOVERY_DEST_FILE","BLOCK_SIZE","FILE_SIZE_BLKS","CON_ID" from gv$controlfile

View Text - HTML Formatted

SELECT "INST_ID"
, "STATUS"
, "NAME"
, "IS_RECOVERY_DEST_FILE"
, "BLOCK_SIZE"
, "FILE_SIZE_BLKS"
, "CON_ID"
FROM GV$CONTROLFILE