Re: many seconds waiting for I/O?
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: amonte <ax.mount@xxxxxxxxx>
- Date: Mon, 30 Jul 2007 00:03:12 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
