show filestat
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
Related examples in the same category