title: GET_TIME in Oracle
body: <p>I have a code that is supposed to give me the compilation time for the procedure, but it only gets me 0 secs! Is the calculation wrong? Is there any other way?</p>
  
  <pre><code>    create or replace PROCEDURE proc_time AS
      v NUMBER := 1;
      x NUMBER := 0;
      counter number := 0;
      summ NUMBER;
      ex_start NUMBER;
      ex_end NUMBER;
      ex_time NUMBER;
      BEGIN
      ex_start := dbms_utility.get_time;
      while  counter &lt;= 19
      loop  
          counter := counter + 1;
          summ := x+v;    
          x := v;
          V := summ;  
          dbms_output.put_line('Fibonacci nr'||counter||': '||summ);
      END loop;
    ex_end := DBMS_UTILITY.GET_TIME;
    ex_time := (ex_end-ex_start)/100; 
    DBMS_OUTPUT.PUT_LINE( 'Exekveringstid: ' || ex_time || ' sekunder.' );
  END;
  /
  </code></pre>