데이터베이스에 의해 사용되고 있는 모든 데이터 파일에 대한 정보
【예제】
SQL> select * from sysfiles;
TSNAME FNAME BLOCKS
---------- -------------------------------------------------- ----------
USERS /export/home/oracle/oradata/orcl/users01.dbf 640
SYSAUX /export/home/oracle/oradata/orcl/sysaux01.dbf 15360
UNDOTBS1 /export/home/oracle/oradata/orcl/undotbs01.dbf 3200
SYSTEM /export/home/oracle/oradata/orcl/system01.dbf 38400
EXAMPLE /export/home/oracle/oradata/orcl/example01.dbf 12800
SQL> desc sysfiles;
Name Null? Type
----------------------------------------- -------- ----------------------------
TSNAME NOT NULL VARCHAR2(30)
FNAME VARCHAR2(513)
BLOCKS NUMBER
SQL>