BTW: the database version is 9205. solaris8 platform.
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
--
Eagle Fan
Oracle DBA
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 23 2007 - 01:33:52 CDT
