Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> get_cpu_time vs. get_time

get_cpu_time vs. get_time

From: <cpiodumpv_at_gmail.com>
Date: 12 Jan 2007 07:45:27 -0800
Message-ID: <1168616727.050542.41090@a75g2000cwd.googlegroups.com>


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;
>/

before=5
after=5

>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;
>/

before=76096444
after=76096945

PL/SQL procedure successfully completed. Received on Fri Jan 12 2007 - 09:45:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US