V$CONTROLFILE
This view lists 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 flash recovery area (YES) or not (NO)
V$CONTROLFILE
This view lists 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 flash recovery area (YES) or not (NO) |
V$CONTROLFILE_RECORD_SECTION
V$CONTROLFILE_RECORD_SECTION displays information about the control file record sections.
| Column | Datatype | Description |
|---|---|---|
| TYPE | VARCHAR2(28) | Identifies the type of record section:
|
| RECORD_SIZE | NUMBER | Record size in bytes |
| RECORDS_TOTAL | NUMBER | Number of records allocated for the section |
| RECORDS_USED | NUMBER | Number of records used in the section |
| FIRST_INDEX | NUMBER | Index (position) of the first record |
| LAST_INDEX | NUMBER | Index of the last record |
| LAST_RECID | NUMBER | Record ID of the last record |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/563971/viewspace-277739/ ，如需转载，请注明出处，否则将追究法律责任。
