Re: CPU_TIME > ELAPSED_TIME

hi:

The server has 8 physical CPU and each one has 2 threads. So CPU_COUNT is 16.

Could you explain more clearly? Do you mean cpu time overlap?

Thanks

On 10/23/07, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> how many cpu's do you have? each of them can do up to 1 second of work
> every second.
>
> On 10/23/07, Eagle Fan <eagle.f_at_gmail.com> wrote:
> >
> > Hi:
> >
> > I have had the same problem before. From v$sql:
> >
> > Delta CPU_TIME > Delta Elapsed_time. The sql is very simple, it's doing
> > "INDEX UNIQUE SCAN" using PK index.'
> >
> > How to explain this?
> >
> > Thanks
> >
> > SQL> select CPU_TIME,ELAPSED_TIME from v$sql where
> > hash_value=1769575534;
> >
> > CPU_TIME ELAPSED_TIME
> > ----------------------- -----------------------
> > 71025140000 70448619327
> >
> > SQL> exec dbms_lock.sleep(300);
> >
> > PL/SQL procedure successfully completed.
> >
> > SQL> select CPU_TIME,ELAPSED_TIME from v$sql where
> > hash_value=1769575534;
> >
> > CPU_TIME ELAPSED_TIME
> > ----------------------- -----------------------
> > 71030920000 70453943000
> >
> > SQL> select (71030920000-71025140000)/(70453943000-70448619327) from
> > dual;
> >
> > (71030920000-71025140000)/(70453943000-70448619327)
> > ---------------------------------------------------
> > 1.08571657
> >
> >
> >
> > --
> > Eagle Fan
> >
> > Oracle DBA
>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info

-- 
Eagle Fan

Oracle DBA

--
http://www.freelists.org/webpage/oracle-l