Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in
news:3E4A07F7.7ADB_at_yahoo.com:
> Chuck wrote:
>>
>> Platform: Oracle 8.1.7
>>
>> I have a script that runs every 10 minutes to check the response time
>> of a query on one of my databases. At the end I am reporting on what
>> events it waited on. I frequently see I/O waits much higher than I
>> expect and would like to see which datafiles it's waiting on. Is
>> there a way to report which datafiles the query accessed and how much
>> time was spent waiting for each one? I know I can query
>> v$session_wait to see what files are being accessed at any given
>> moment, but that's not what I want. I want to see the total time
>> waited on each datafile but just for the one session.
>>
>> Thanks in advance.
>
> v$sess_io
>
> hth
> connor
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 have no
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.
Received on Wed Feb 12 2003 - 13:15:13 CST
