Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: i/o waits by session?
If you want to see the I/O for a particular application usage.
Have only one session accessing the database, collect file I/O
statistics using v$FILESTAT, run the application for some time and run
V$FILESTAT to collect end statistics.
The difference is the file I/O usage of your application file wise.
regards
Srivenu
Received on Sat Sep 07 2002 - 01:58:30 CDT