Re: CPU_TIME > ELAPSED_TIME

  • From: amit poddar <amit.poddar@xxxxxxxx>
  • To: anjo.kolk@xxxxxxxxxxx
  • Date: Wed, 24 Oct 2007 20:08:21 -0400

Hi anjo,

Is this true for all the platforms ?

amit

Anjo Kolk 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 <mailto: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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2007