Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba data files

show filestat

   <source lang="sql">

SQL> select tablespace_name, file_name, PHYRDS, PHYWRTS, PHYBLKRD, PHYBLKWRT

 2  from v$filestat, dba_data_files
 3  where file_id = file#
 4  order by PHYRDS, PHYWRTS desc
 5  /

TABLESPACE_NAME FILE_NAME PHYRDS PHYWRTS PHYBLKRD PHYBLKWRT

---

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

DATA_1 C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABAS 14 8 14 8

                    E\DATA_1B.DBF

DATA_1 C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABAS 15 8 15 8

                    E\DATA_1A.DBF

USERS C:\ORACLEXE\ORADATA\XE\USERS.DBF 24 30 24 57 UNDO C:\ORACLEXE\ORADATA\XE\UNDO.DBF 1,252 8,112 1,252 18,054 SYSAUX C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF 2,093 1,450 3,476 1,624 SYSTEM C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF 21,550 11,387 58,012 20,835 6 rows selected. SQL> spool off</source>