Re: CPU_TIME > ELAPSED_TIME
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: eagle.f@xxxxxxxxx
- Date: Tue, 23 Oct 2007 08:42:57 +0100
how many cpu's do you have? each of them can do up to 1 second of work every
second.
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
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
