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