This lists the names of the control files.
The most relevant view fields are as follows:
STATUS
: This is null if the name can be determined,INVALID
otherwiseNAME
: The control filenameIS_RECOVERY_DEST_FILE
: This indicates whether the control file was created in the fast recovery area (YES
) or not (NO
)BLOCK_SIZE
: The control file block sizeFILE_SIZE_BLKS
: The control file size in blocks