oracle参数文件记录的信息,Oracle脚本-查询数据文件I/O信息

```sql

SQL> SELECT fs.phyrds "Reads",

2 fs.phywrts "Writes",

3 fs.avgiotim "Average I/O Time",

4 df.name "Datafile"

5 FROM v$datafile df, v$filestat fs

6 WHERE df.file# = fs.file#;

Reads Writes Average I/O Time Datafile

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

4985 16 0 /u01/oracle/oradata/orcl/system01.dbf

1017 301 0 /u01/oracle/oradata/orcl/sysaux01.dbf

59 19 2 /u01/oracle/oradata/orcl/undotbs01.dbf

2 0 0 /u01/oracle/oradata/orcl/users01.dbf

7 0 0 /u01/oracle/oradata/orcl/example01.dbf

2 0 0 /u01/oracle/oradata/orcl/SYSTEM02.dbf

2 0 0 /u01/oracle/oradata/orcl/USERS02.dbf

2 0 0 /u01/oracle/oradata/orcl/SYSAUX02.dbf

2 0 0 /u01/oracle/oradata/orcl/EXAMPLE02.dbf

28 13 0 /u01/oracle/oradata/orcl/UNDOTBS102.dbf

10 rows selected

```