動(dòng)態(tài)性能視圖v$datafile顯示了數(shù)據(jù)文件的信息，這些信息來源自于控制文件。：V$DATAFILE displays datafile information from the control file.
| 列：Column | 數(shù)據(jù)類型：Datatype | 描述：Description |
|---|---|---|
FILE# | NUMBER | 數(shù)據(jù)文件的ID號(hào)：File identification number |
CREATION_CHANGE# | NUMBER | 數(shù)據(jù)文件創(chuàng)建時(shí)的SCN值：Change number at which the datafile was created |
CREATION_TIME | DATE | 數(shù)據(jù)文件創(chuàng)建的時(shí)間：Timestamp of the datafile creation |
TS# | NUMBER | 表空間ID：Tablespace number |
RFILE# | NUMBER | Tablespace relative datafile number |
STATUS | VARCHAR2(7) | 文件的類型及其狀態(tài)，值有offline,online,system,recover,sysoff(system表空間當(dāng)中的離線文件)。：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) | 描述了數(shù)據(jù)文件的可訪問性：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 | 當(dāng)前數(shù)據(jù)文件的大小，以字節(jié)為單位，如果不可訪問，則值為0:Current datafile size (in bytes); 0 if inaccessible |
BLOCKS | NUMBER | 當(dāng)前數(shù)據(jù)文件的數(shù)據(jù)塊個(gè)數(shù)，如果不可訪問，則值為0，關(guān)于bytes,blocks,block_size有這樣的關(guān)系：bytes=blocks*block_size即，數(shù)據(jù)文件的大小等于此數(shù)據(jù)文件所占用的數(shù)據(jù)塊個(gè)數(shù)乘以單個(gè)數(shù)據(jù)塊的大小，其中block_size的值與parameter參數(shù)文件的db_block_size的值是相同的:Current datafile size (in blocks); 0 if inaccessible |
CREATE_BYTES | NUMBER | 創(chuàng)建時(shí)的大?。ㄒ宰止?jié)為單位）：Size when created (in bytes) |
BLOCK_SIZE | NUMBER | 數(shù)據(jù)文件的塊大小：Block size of the datafile |
NAME | VARCHAR2(513) | 數(shù)據(jù)文件的名字（含路徑）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)系客服
