Re: CPU_TIME > ELAPSED_TIME

hi Chao:

Seems solaris10 doesn't have the rounding problem.

SQL> select hash_value,cpu_time,elapsed_time from v$sql where hash_value=1270345899;

HASH_VALUE CPU_TIME ELAPSED_TIME

---------- ------------------- -------------------------
1270345899           916902445                 916879035

On 10/28/07, Zhu,Chao <zhuchao_at_gmail.com> wrote:
>
> What about in solaris 10 when it start to use microstate accounting?
> Do we still have the same problem?
>
> On 10/25/07, Eagle Fan < eagle.f_at_gmail.com> wrote:
> >
> > 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
>
>
>
>
> --
> Regards
> Zhu Chao
> www.cnoug.org
>

-- 
Eagle Fan

Oracle DBA

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