Oracle教程 2023-03-21

Oracle 视图 V$CONTROLFILE_RECORD_SECTION 官方解释，作用，如何使用详细说明

Oracle视图V$CONTROLFILE_RECORD_SECTION是Oracle自己管理的视图，查询控制文件中保存的相关信息，这些信息可以提供控制文件中每一行记录，每一行所对应的数据库对象，以及对应对象的定位偏移量等信息。

使用方法：

1. 用下面的SQL语句查看控制文件的所有记录：

SELECT * FROM V$CONTROLFILE_RECORD_SECTION;

2. 查看控制文件特定记录，可以使用TYPE字段来定位：

SELECT * FROM V$CONTROLFILE_RECORD_SECTION
WHERE TYPE=’DATAFILE’;

3. 如果需要查看控制文件特定记录的具体位置，可以使用OFFSET和BLOCKSIZE字段进行定位：

SELECT OFFSET, BLOCKSIZE FROM V$CONTROLFILE_RECORD_SECTION
WHERE TYPE=’DATAFILE’;

V$CONTROLFILE_RECORD_SECTION displays information about the control file record sections.

Column	Datatype	Description
`TYPE`	`VARCHAR2(28)`	Identifies the type of record section: `DATABASE` `CKPT PROGRESS` `REDO THREAD` `REDO LOG` `DATAFILE` `FILENAME` `TABLESPACE` `TEMPORARY FILENAME` `RMAN CONFIGURATION` `LOG HISTORY` `OFFLINE RANGE` `ARCHIVED LOG` `BACKUP SET` `BACKUP PIECE` `BACKUP DATAFILE` `BACKUP REDOLOG` `DATAFILE COPY` `BACKUP CORRUPTION` `COPY CORRUPTION` `DELETED OBJECT` `PROXY COPY` `BACKUP SPFILE` `DATABASE INCARNATION` `FLASHBACK LOG` `RECOVERY DESTINATION` `INSTANCE SPACE RESERVATION` `REMOVABLE RECOVERY FILES` `RMAN STATUS` `THREAD INSTANCE NAME MAPPING` `MTTR` `DATAFILE HISTORY` `PLUGGED` `IN` `DATAFILE`
`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
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：