Re: many seconds waiting for I/O?

V$SESS_IO gives you cumulative statistics for the session. V$SESSION columns WAIT_TIME, SECONDS_IN_WAIT and STATE present only the *current* wait.

If db_file_sequential_read is always your wait, rather than CONSISTENT_GETS, look at
PHYSICAL_READS from V$SESS_IO.

Also, use V$SESSION_EVENT to see cumulative waits for the session -- then you will know which event the session has spent the most time on. You can take incremental
snapshots of V$SESSION_EVENT to identify the waits between intervals.

Hemant K Chitale

At 10:39 PM Friday, amonte wrote:
>Hi
>
>I was joining v$session, v$sess_io, and v$process, the interval
>every 5 to 10 seconds
>
>Thanks
>
>Alex
>
>
>

Hemant K Chitale
http://hemantoracledba.blogspot.com

--
http://www.freelists.org/webpage/oracle-l