Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: many seconds waiting for I/O?

Re: many seconds waiting for I/O?

From: LS Cheng <exriscer_at_gmail.com>
Date: Sun, 29 Jul 2007 19:40:30 +0200
Message-ID: <6e9345580707291040w15a64d5dqac6627445c5ff655@mail.gmail.com>


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_at_singnet.com.sg> 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
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Sun Jul 29 2007 - 12:40:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US