Re: CPU_TIME > ELAPSED_TIME

You are right. The CPU_Time is always times of 10 000.

So I agree with you that's rounding errors:)

Thanks Anjo.

On 10/25/07, Anjo Kolk <anjo.kolk_at_oraperf.com> wrote:
>
> The CPU time is really measured in Centi Seconds and multiplied with 10000
> to be micro seconds. The elapsed time is really micro seconds. So you can
> get some interesting rounding errors :)
>
> Anjo.
>
>
> 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
>
>
>
>
> --
> Anjo Kolk
> Owner and Founder OraPerf Projects
> tel: +31-577-712000
> mob: +31-6-55340888

-- 
Eagle Fan

Oracle DBA

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