Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: I/O waits
Andrew Allen <andrew.allen_at_handleman.com> wrote in news:3E4AAC3E.3070401
@handleman.com:
> Chuck wrote: >> Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in >> news:3E4A07F7.7ADB_at_yahoo.com: >> >>
>> >> >> This tells me how many I/O's my session did, but is not broken down by >> datafiles. What I really need to see is the i/o waits per datafile. I >> strongly suspect I am seeing disk contention within a SAN but I haveno
>> access to what is placed where in the SAN. To the DBAs it's just a big >> black box of disk space. If I can see which files the waits are >> occurring on, I can tell the folks who manage the SAN where to look. > > Statspack is probably what you should be using.
>
That gives me stats for the entire instance over a period of time. I need it for one session. Received on Wed Feb 12 2003 - 14:55:08 CST