CPU_TIME > ELAPSED_TIME

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 23 2007 - 01:02:04 CDT