Call dbms_utility.get_time twice to time a statement in PL SQL

   
SQL>
SQL> create table t ( x int );

Table created.

SQL>
SQL> set serveroutput on
SQL>
SQL> declare
  2          l_start number default dbms_utility.get_time;
  3  begin
  4          for i in 1 .. 1000
  5          loop
  6                  insert into t values ( 1 );
  7          end loop;
  8          commit;
  9          dbms_output.put_line( dbms_utility.get_time-l_start || ' hsecs' );
 10  end;
 11  /
21 hsecs

PL/SQL procedure successfully completed.

SQL>
SQL> drop table t;

Table dropped.

SQL> --

Related examples in the same category

1.	This script demonstrates DBMS_UTILITY.NAME_TOKENIZE.
2.	Use dbms_utility to time
3.	time to commit
4.	dbms_utility.get_parameter_value
5.	round dbms_utility.get_time
6.	Assign dbms_utility.get_time to integer variable
7.	Use dbms_utility.get_time to do performace check
8.	dbms_utility.format_error_stack
9.	Timing Per Thousand Records Processed (in secs)
10.	Timing Package function call
11.	use DBMS_UTILITY.FORMAT_ERROR_STACK in a SERVERERROR trigger.
12.	DBMS_UTILITY.analyze_schema
13.	demonstrates the use of DBMS_UTILITY.TABLE_TO_COMMA and DBMS_UTILITY.COMMA_TO_TABLE.
14.	Performace difference between simple parameter and collection parameter

Call dbms_utility.get_time twice to time a statement in PL SQL : dbms_utility « System Packages « Oracle PL / SQL

Related examples in the same category