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@xxxxxxxxxxx> 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@xxxxxxxxx> 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