ITPub博客

首页 > Linux操作系统 > Linux操作系统 > v$filestat查看读写情况

v$filestat查看读写情况

原创 Linux操作系统 作者:adeng56 时间:2012-06-23 10:45:43 0 删除 编辑
[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博客 ” ,链接:http://blog.itpub.net/27027903/viewspace-733635/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2012-06-12

  • 博文量
    6
  • 访问量
    4500