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)
DBA_DATAFILES contains a record for each data file in the database - files that are part of tablespaces. It holds similar information to v$datafile, but has the advantage of showing the tablespace to which the file belongs:
break on tablespace_name
select tablespace_name
, file_name
from dba_data_files
/
TABLESPACE_NAME FILE_NAME
-------------------- ---------------------------------
USERS /u01/oradata/scr10e/users01.dbf
SYSAUX /u01/oradata/scr10e/sysaux01.dbf
UNDOTBS1 /u01/oradata/scr10e/undotbs01.dbf
SYSTEM /u01/oradata/scr10e/system01.dbf
ANDY /u01/oradata/scr10e/andy01.dbf
5 rows selected.
For more useful DBA queries click here.
| 