FILE# |
NUMBER |
数据文件的ID号：File identification number |
CREATION_CHANGE# |
NUMBER |
数据文件创建时的SCN值：Change number at which the datafile was created |
CREATION_TIME |
DATE |
数据文件创建的时间：Timestamp of the datafile creation |
TS# |
NUMBER |
表空间ID：Tablespace number |
RFILE# |
NUMBER |
Tablespace relative datafile number |
STATUS |
VARCHAR2(7) |
文件的类型及其状态，值有offline,online,system,recover,sysoff(system表空间当中的离线文件)。：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) |
描述了数据文件的可访问性：Describes how accessible the file is from SQL:
-
disable --不允许SQL语句访问：DISABLED - No SQL access allowed
-
read only --只读，不允许更新操作： READ ONLY - No SQL updates allowed
-
read write--可读写状态，允许任何操作：READ WRITE - Full access allowed
-
unknown--此种情况不应该发生，除非控制文件出现问题：UNKNOWN - should not occur unless the control file is corrupted
|
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 |
当前数据文件的大小，以字节为单位，如果不可访问，则值为0:Current datafile size (in bytes); 0 if inaccessible |
BLOCKS |
NUMBER |
当前数据文件的数据块个数，如果不可访问，则值为0，关于bytes,blocks,block_size有这样的关系：bytes=blocks*block_size即，数据文件的大小等于此数据文件所占用的数据块个数乘以单个数据块的大小，其中block_size的值与parameter参数文件的db_block_size的值是相同的:Current datafile size (in blocks); 0 if inaccessible |
CREATE_BYTES |
NUMBER |
创建时的大小（以字节为单位）：Size when created (in bytes) |
BLOCK_SIZE |
NUMBER |
数据文件的块大小：Block 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 |
??? |
