Simple Question on Oracle dbms_utility.get_time
-
dbms_utility.get_time It seems like dbms_utility.get_time is not giving me the correct time...? SET TIMING ON; DECLARE i NUMBER :=0; time1 NUMBER; time2 NUMBER; BEGIN time1:=dbms_utility.get_time; LOOP i:=i+1; DBMS_OUTPUT.PUT_LINE(i); EXIT WHEN i>1000; END LOOP; time2:=dbms_utility.get_time; DBMS_OUTPUT.PUT_LINE(time1); DBMS_OUTPUT.PUT_LINE(time2); DBMS_OUTPUT.PUT_LINE('time elapsed in ms: ' || (time2-time1) /100*1000 ); END; The output of the above script: ... ... 997 998 999 1000 1001 862757 862757 time elapsed in ms: 0 PL/SQL procedure successfully completed. Elapsed: 00:00:11.25 *** It seems like get_time is not returning the correct time... What's happenning? *** THANKS in advance! Norman Fung
-
dbms_utility.get_time It seems like dbms_utility.get_time is not giving me the correct time...? SET TIMING ON; DECLARE i NUMBER :=0; time1 NUMBER; time2 NUMBER; BEGIN time1:=dbms_utility.get_time; LOOP i:=i+1; DBMS_OUTPUT.PUT_LINE(i); EXIT WHEN i>1000; END LOOP; time2:=dbms_utility.get_time; DBMS_OUTPUT.PUT_LINE(time1); DBMS_OUTPUT.PUT_LINE(time2); DBMS_OUTPUT.PUT_LINE('time elapsed in ms: ' || (time2-time1) /100*1000 ); END; The output of the above script: ... ... 997 998 999 1000 1001 862757 862757 time elapsed in ms: 0 PL/SQL procedure successfully completed. Elapsed: 00:00:11.25 *** It seems like get_time is not returning the correct time... What's happenning? *** THANKS in advance! Norman Fung