Re: many seconds waiting for I/O?

Hi Alex

If the program being run is a stored package or procedure then most probably
is program logic burning CPU.

Thanks

--
LSC



On 7/29/07, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> wrote:
>
>
> 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: