| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
V$CONTROLFILE displays the names of the control files.
| Column | Datatype | Description | 
|---|---|---|
STATUS | 
VARCHAR2(7) | 
INVALID if the name cannot be determined (which should not occur); NULL if the name can be determined | 
NAME | 
VARCHAR2(513) | 
Name of the control file | 
IS_RECOVERY_DEST_FILE | 
VARCHAR2(3) | 
Indicates whether the file was created in the fast recovery area (YES) or not (NO) | 
BLOCK_SIZE | 
NUMBER | 
Control file block size | 
FILE_SIZE_BLKS | 
NUMBER | 
Control file size (in blocks) |