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 > > > > -- > //www.freelists.org/webpage/oracle-l > > >