v$datafile各属性解释
http://youngcow.net/doc/oracle10g/server.102/b14237/dynviews_1076.htm
[@more@]1、created_change# --scn_to_timestamp 转换成建立时间；2、status:system,online,offline;3enabled :read only ,read write,disable;
4、checkpoint_change#,checkpoint_time--当alter database datafile ' resize 5m的时候触发改变；...
执行alter system switch logfile或者alter system flush buffer_cache或者alter system archive log current以后各个数据文件记录的检查点统一和日志文件对齐
525357 2009-9-17 11:07:18
525357 2009-9-17 11:07:18
525357 2009-9-17 11:07:18
525357 2009-9-17 11:07:18
525357 2009-9-17 11:07:18
5、offline_change#:最近一次的alter datafile ... offline;
6、online_change#,online_time最近一次的alter datafile ... online;
7、bytes,blocks,create_bytes : 当前大小，当前块数，初始建立的大小;name:文件路径和名称；
8、UNRECOVERABLE_CHANGE#,last_change#:alter system switch logfilearchive log currentflush buffer_cache都不能影响这些属性
n、其他属性就不知道了...
| Column | Datatype | Description |
|---|---|---|
FILE# | NUMBER | File identification number |
CREATION_CHANGE# | NUMBER | Change number at which the datafile was created |
CREATION_TIME | DATE | Timestamp of the datafile creation |
TS# | NUMBER | Tablespace number |
RFILE# | NUMBER | Tablespace relative datafile number |
STATUS | VARCHAR2(7) | 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:
|
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 | Current datafile size (in bytes); 0 if inaccessible |
BLOCKS | NUMBER | 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 |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/450962/viewspace-1027052/ ，如需转载，请注明出处，否则将追究法律责任。
