20.Oracle杂记——Oracle常用动态视图v$datafile

20.Oracle杂记——Oracle常用动态视图v$datafile

视图v$datafile：数据库使用的数据文件信息

显示的信息是来自控制文件的。

视图描述如下：

sys@PDB1> desc v$datafile;

 Name                                                                                                     Null?         Type

 ------------------------------------------------------------- ------------------------------------

 FILE#                                                                                                                                   NUMBER

 CREATION_CHANGE#                                                                                                   NUMBER

 CREATION_TIME                                                                                                                             DATE

 TS#                                                                                                                                      NUMBER

 RFILE#                                                                                                                               NUMBER

 STATUS                                                                                                                            VARCHAR2(7)

 ENABLED                                                                                                                           VARCHAR2(10)

 CHECKPOINT_CHANGE#                                                                                              NUMBER

 CHECKPOINT_TIME                                                                                                      DATE

 UNRECOVERABLE_CHANGE#                                                                                                       NUMBER

 UNRECOVERABLE_TIME                                                                                             DATE

 LAST_CHANGE#                                                                                                              NUMBER

 LAST_TIME                                                                                                                      DATE

 OFFLINE_CHANGE#                                                                                                      NUMBER

 ONLINE_CHANGE#                                                                                                       NUMBER

 ONLINE_TIME                                                                                                                 DATE

 BYTES                                                                                                                                 NUMBER

 BLOCKS                                                                                                                             NUMBER

 CREATE_BYTES                                                                                                               NUMBER

 BLOCK_SIZE                                                                                                                     NUMBER

 NAME                                                                                                                                 VARCHAR2(513)

 PLUGGED_IN                                                                                                                    NUMBER

 BLOCK1_OFFSET                                                                                                                              NUMBER

 AUX_NAME                                                                                                                      VARCHAR2(513)

 FIRST_NONLOGGED_SCN                                                                                                             NUMBER

 FIRST_NONLOGGED_TIME                                                                                                          DATE

 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

 CON_ID                                                                                                                            NUMBER

解释如下：

FILE#：文件ID

 CREATION_CHANGE#：数据文件创建时候的改变号

 CREATION_TIME：创建时间

 TS#        ：文件所属表空间的号

 RFILE# ：表空间相对文件数字

 STATUS ：文件类型和状态

 ENABLED：如何通过SQL访问文件（DISABLED,READONLY,READ WRITE,UNKOWN）

 CHECKPOINT_CHANGE#： 上一次CHECKPINT的SCN

 CHECKPOINT_TIME：CHECKPOINT的时间

 UNRECOVERABLE_CHANGE#：上一次不可改变的改变号。在归档模式下，才会更新。

 UNRECOVERABLE_TIME：上一次不可改变发生的时间

 LAST_CHANGE#：上一次对文件的改变号

 LAST_TIME：上一次改变的时间

 OFFLINE_CHANGE#：上一次离线的改变号。在文件再一次上线后更新该列

 ONLINE_CHANGE#：上一次离线后的上线改变号

 ONLINE_TIME：上一次离线后的上线时间

 BYTES：当前文件大小，0的话表示不可访问

 BLOCKS ：当前文件块大小，0的话表示不可访问

 CREATE_BYTES：创建时候的大小

 BLOCK_SIZE：文件的块大小

 NAME：文件的名字

 PLUGGED_IN        ：表示表空间是否是插入的

 BLOCK1_OFFSET：Oracle通用信息开始的地方离文件开始多远

 AUX_NAME：通过CONFIGURE AUXNAME设置的辅助名字

 FIRST_NONLOGGED_SCN：第一次nonloggedSCN

 FIRST_NONLOGGED_TIME：第一次nonlogged时间

 FOREIGN_DBID：如果文件来自外部数据库，外部数据库的DBID

 FOREIGN_CREATION_CHANGE#：外部文件的创建SCN号

 FOREIGN_CREATION_TIME：外部文件的创建时间

 PLUGGED_READONLY：传输过来只读的外部文件？

 PLUGIN_CHANGE#：外部文件传输到数据库的SCN号

 PLUGIN_RESETLOGS_CHANGE#：当外部文件传输进来的时候，RESETLOGS操作的SCN

 PLUGIN_RESETLOGS_TIME：当外部文件传输进来的时候，RESETLOGS操作的时间

 CON_ID：拥有该数据的容器ID。