Re: CPU_TIME > ELAPSED_TIME

BTW: the database version is 9205. solaris8 platform.

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




-- 
Eagle Fan

Oracle DBA

Other related posts: