round dbms_utility.get_time : dbms_utility « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. dbms_utility

round dbms_utility.get_time

   
SQL>
SQL> declare l_tmp char(1);
  2  l_start number := dbms_utility.get_time;
  3  begin
  4  select * into l_tmp from dual;
  5  dbms_output.put_line( round( (dbms_utility.get_time-l_start)/100, 2 )||' seconds' );
  6  end;
  7  /
0 seconds

PL/SQL procedure successfully completed.

SQL>
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.Call dbms_utility.get_time twice to time a statement in PL SQL
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