Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to figure out how many IOs a SQL costs ?
View V$SESS_IO shows some IO info per session (not writes).
Another way is to activate tracing for the session and run tkprof on the
trace file.
The output of tkprof shows logical and physical IO per statement.
Bass Chorng <bchorng_at_yahoo.com> schreef in berichtnieuws
bd9a9a76.0210151424.6e388003_at_posting.google.com...
| I don't see that Oracle has # of IOs as a statistic, but this seems to
| be a common question. If I am right, disk in tkprof or disk_reads in
| v$sql all refer to # of blocks. I have yet to find a direct way to
| tell # of IOs incurred.
|
| The closet I can think of is, suppose you can control the environment,
| the difference of SUM(PHYRDS+PHYWRTS) in v$filestat before and after a
| SQL run, plus the value of "redo writes" in v$sesstat.
|
| Does this do the job, or I am missing something else ?
|
| Thanks for your input in advance.
Received on Tue Oct 15 2002 - 17:30:41 CDT