Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> get_cpu_time vs. get_time
can someone explain this?
>list
1 declare
2 l_temp number;
3 begin
4 l_temp := DBMS_UTILITY.get_cpu_time; 5 dbms_output.put_line ( 'before=' || l_temp ); 6 dbms_lock.sleep ( 5 ); 7 l_temp := DBMS_UTILITY.get_cpu_time; 8 dbms_output.put_line ( 'after=' || l_temp );9* end;
>list
1 declare
2 l_temp number;
3 begin
4 l_temp := DBMS_UTILITY.get_time; 5 dbms_output.put_line ( 'before=' || l_temp ); 6 dbms_lock.sleep ( 5 ); 7 l_temp := DBMS_UTILITY.get_time; 8 dbms_output.put_line ( 'after=' || l_temp );9* end;
PL/SQL procedure successfully completed. Received on Fri Jan 12 2007 - 09:45:27 CST