動(dòng)態(tài)性能視圖v$datafile顯示了數據文件的信息，這些信息來(lái)源自于控制文件。：V$DATAFILE displays datafile information from the control file.
| 列：Column | 數據類(lèi)型：Datatype | 描述：Description |
|---|---|---|
FILE# | NUMBER | 數據文件的ID號：File identification number |
CREATION_CHANGE# | NUMBER | 數據文件創(chuàng )建時(shí)的SCN值：Change number at which the datafile was created |
CREATION_TIME | DATE | 數據文件創(chuàng )建的時(shí)間：Timestamp of the datafile creation |
TS# | NUMBER | 表空間ID：Tablespace number |
RFILE# | NUMBER | Tablespace relative datafile number |
STATUS | VARCHAR2(7) | 文件的類(lèi)型及其狀態(tài)，值有offline,online,system,recover,sysoff(system表空間當中的離線(xiàn)文件)。：Type of file (system or user) and its status. Values: OFFLINE, ONLINE, SYSTEM, RECOVER, SYSOFF (an offline file from the SYSTEM tablespace) |
ENABLED | VARCHAR2(10) | 描述了數據文件的可訪(fǎng)問(wèn)性：Describes how accessible the file is from SQL:
|
CHECKPOINT_CHANGE# | NUMBER | SCN at last checkpoint |
CHECKPOINT_TIME | DATE | Timestamp of the checkpoint# |
UNRECOVERABLE_CHANGE# | NUMBER | Last unrecoverable change number made to this datafile. If the database is in ARCHIVELOG mode, then this column is updated when an unrecoverable operation completes. If the database is not in ARCHIVELOG mode, this column does not get updated. |
UNRECOVERABLE_TIME | DATE | Timestamp of the last unrecoverable change. This column is updated only if the database is in ARCHIVELOG mode. |
LAST_CHANGE# | NUMBER | Last change number made to this datafile (null if the datafile is being changed) |
LAST_TIME | DATE | Timestamp of the last change |
OFFLINE_CHANGE# | NUMBER | Offline change number of the last offline range. This column is updated only when the datafile is brought online. |
ONLINE_CHANGE# | NUMBER | Online change number of the last offline range |
ONLINE_TIME | DATE | Online timestamp of the last offline range |
BYTES | NUMBER | 當前數據文件的大小，以字節為單位，如果不可訪(fǎng)問(wèn)，則值為0:Current datafile size (in bytes); 0 if inaccessible |
BLOCKS | NUMBER | 當前數據文件的數據塊個(gè)數，如果不可訪(fǎng)問(wèn)，則值為0，關(guān)于bytes,blocks,block_size有這樣的關(guān)系：bytes=blocks*block_size即，數據文件的大小等于此數據文件所占用的數據塊個(gè)數乘以單個(gè)數據塊的大小，其中block_size的值與parameter參數文件的db_block_size的值是相同的:Current datafile size (in blocks); 0 if inaccessible |
CREATE_BYTES | NUMBER | 創(chuàng )建時(shí)的大?。ㄒ宰止潪閱挝唬篠ize when created (in bytes) |
BLOCK_SIZE | NUMBER | 數據文件的塊大?。築lock size of the datafile |
NAME | VARCHAR2(513) | 數據文件的名字（含路徑）Name of the datafile |
PLUGGED_IN | NUMBER | Describes whether the tablespace is plugged in. The value is 1 if the tablespace is plugged in and has not been made read/write, 0 if not. |
BLOCK1_OFFSET | NUMBER | Offset from the beginning of the file to where the Oracle generic information begins. The exact length of the file can be computed as follows: BYTES + BLOCK1_OFFSET. |
AUX_NAME | VARCHAR2(513) | Auxiliary name that has been set for this file via CONFIGURE AUXNAME |
FIRST_NONLOGGED_SCN | NUMBER | First nonlogged SCN |
FIRST_NONLOGGED_TIME | DATE | First nonlogged time |
FOREIGN_DBID | NUMBER | ??? |
FOREIGN_CREATION_CHANGE# | NUMBER | ??? |
FOREIGN_CREATION_TIME | DATE | ??? |
PLUGGED_READONLY | VARCHAR2(3) | ??? |
PLUGIN_CHANGE# | NUMBER | ??? |
PLUGIN_RESETLOGS_CHANGE# | NUMBER | ??? |
PLUGIN_RESETLOGS_TIME | DATE | ??? |
聯(lián)系客服
