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