Oracle SQL总结 - 1
@>select NAME , PHYRDS , PHYWRTS from v$filestat f, v$datafile d where f.FILE# = d.FILE# order by PHYWRTS desc ; NAME PHYRDS PHYWRTS--------------------------------------------- ---------- ----------
/home/oracle/oradata/moree/perfstat.dbf 217 1135
/home/oracle/oradata/moree/undotbs01.dbf 20 278
/home/oracle/oradata/moree/undotbs02.dbf 13 200
/home/oracle/oradata/moree/system01.dbf 608 102
/home/oracle/oradata/moree/undotbs03.dbf 9 72
/home/oracle/oradata/moree/tools01.dbf 3 1
/home/oracle/oradata/moree/APPINDX1M01.dbf 3 1
/home/oracle/oradata/moree/APP_DATA1K01.dbf 3 1
/home/oracle/oradata/moree/APPDATA1M01.dbf 3 1
/home/oracle/oradata/moree/MCSHADOWTS01.dbf 3 1
/home/oracle/oradata/moree/APPINDX1K02.dbf 3 1
/home/oracle/oradata/moree/APP_DATA1K05.dbf 3 1
/home/oracle/oradata/moree/APP_DATA1K04.dbf 3 1
页:
[1]