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

Other related posts: