dbms_utility « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. dbms_utility
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.round dbms_utility.get_time
7.Assign dbms_utility.get_time to integer variable
8.Use dbms_utility.get_time to do performace check
9.dbms_utility.format_error_stack




10.Timing Per Thousand Records Processed (in secs)
11.Timing Package function call
12.use DBMS_UTILITY.FORMAT_ERROR_STACK in a SERVERERROR trigger.
13.DBMS_UTILITY.analyze_schema
14.demonstrates the use of DBMS_UTILITY.TABLE_TO_COMMA and DBMS_UTILITY.COMMA_TO_TABLE.
15.Performace difference between simple parameter and collection parameter