Re: I/O waits

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 12 Feb 2003 16:38:15 +0800
Message-ID: <3E4A07F7.7ADB@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 Received on Wed Feb 12 2003 - 02:38:15 CST