CPU_TIME > ELAPSED_TIME
- From: "Eagle Fan" <eagle.f@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 23 Oct 2007 14:02:04 +0800
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
Other related posts:
