[oracle@oracle11g ~]$ vi datafile_filestat.sql
select phyrds,phywrts,d.name
from v$datafile d,v$filestat f
where d.file#=f.file#
order by f.file#;
~
~
SQL> @/home/oracle/datafile_filestat
PHYRDS PHYWRTS NAME
---------- ---------- ------------------------------
6920 43 /u01/oradata/dl1/system01.dbf
857 306 /u01/oradata/dl1/sysaux01.dbf
23 81 /u01/oradata/dl1/undotbs01.dbf
2 0 /u01/oradata/dl1/users01.dbf
2 0 /u01/oradata/dl1/assm_1.dbf
2 0 /u01/oradata/dl1/mssm_1.dbf
2 0 /u01/oradata/dl1/app1.dbf
2 0 /u01/oradata/dl1/app2.dbf
422 260 /u01/oradata/dl1/stpack.dbf
9 rows selected.
select d.file_name,d.tablespace_name,phyrds,phywrts
from dba_data_files d,v$filestat f
where d.file_id=f.file#
Order by f.file#;
~
~
SQL> @/home/oracle/filestat.sql
FILE_NAME TABLESPACE_NAME PHYRDS PHYWRTS
------------------------------ -------------------- ---------- ----------
/u01/oradata/dl1/system01.dbf SYSTEM 6920 41
/u01/oradata/dl1/sysaux01.dbf SYSAUX 857 303
/u01/oradata/dl1/undotbs01.dbf UNDOTBS1 23 77
/u01/oradata/dl1/users01.dbf USERS 2 0
/u01/oradata/dl1/assm_1.dbf ASSM 2 0
/u01/oradata/dl1/mssm_1.dbf MSSM 2 0
/u01/oradata/dl1/app1.dbf APP1 2 0
/u01/oradata/dl1/app2.dbf APP2 2 0
/u01/oradata/dl1/stpack.dbf STSPACK 422 260
9 rows selected.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/27027903/viewspace-733635/
,如需转载,请注明出处,否则将追究法律责任。