Data files

1、查看Data File 结构

SQL> desc dba_data_files;
 Name                                                                                                              Null?    Type
 ----------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------
 FILE_NAME                                                                                                                  VARCHAR2(513)
 FILE_ID                                                                                                                    NUMBER
 TABLESPACE_NAME                                                                                                            VARCHAR2(30)
 BYTES                                                                                                                      NUMBER
 BLOCKS                                                                                                                     NUMBER
 STATUS                                                                                                                     VARCHAR2(9)
 RELATIVE_FNO                                                                                                               NUMBER
 AUTOEXTENSIBLE                                                                                                             VARCHAR2(3)
 MAXBYTES                                                                                                                   NUMBER
 MAXBLOCKS                                                                                                                  NUMBER
 INCREMENT_BY                                                                                                               NUMBER
 USER_BYTES                                                                                                                 NUMBER
 USER_BLOCKS                                                                                                                NUMBER
 ONLINE_STATUS                                                                                                              VARCHAR2(7)

2、查看数据文件详细信息

SQL> select file_name,tablespace_name from dba_data_files;
/u01/oradata/poli/users01.dbf            USERS
/u01/oradata/poli/undotbs01.dbf          UNDOTBS1
/u01/oradata/poli/sysaux01.dbf           SYSAUX
/u01/oradata/poli/system01.dbf           SYSTEM
/u01/oradata/poli/example01.dbf          EXAMPLE

3、来自动态性能视图v$datafile的数据文件信息

SQL> select file#,name from v$datafile;

     FILE# NAME
---------- ------------------------------------------------------------
         1 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\SYSTEM01.DBF
         2 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\SYSAUX01.DBF
         3 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\UNDOTBS01.DBF
         4 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\USERS01.DBF
         5 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\EXAMPLE01.DBF
         6 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\ASSM_1.DBF
         7 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\MSSM_1.DBF
         8 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\APP_DATA_01.DBF
         9 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\APP_TEST01.DBF

9 rows selected.