advanced code snippet search

Posted By

geekzspot on 10/19/12


Tagged

Oracle PLSQL


Versions (?)

PL/SQL Elapsed time

 / Published in: PL/SQL
 

Calculate and display the elapsed time for PL/SQL code

Expand | Embed | Plain Text 
  1. SET SERVEROUTPUT ON
  2.  
  3. DECLARE
  4.   start_time INTEGER;
  5.   stop_time INTEGER;
  6. BEGIN
  7.   start_time := DBMS_UTILITY.GET_TIME;
  8.   DBMS_LOCK.SLEEP(42);
  9.   stop_time := DBMS_UTILITY.GET_TIME;
  10.   DBMS_OUTPUT.PUT_LINE(TO_CHAR((stop_time - start_time)/100) || ' seconds');
  11. END;
  12. /
  13.  
  14. 42 seconds

Report this snippet  

You need to login to post a comment.