Oracle8i provides a standard package, DBMS_PROFILER, which facilitates performance and code coverage analysis of your PL/SQL application. This package provides functions for gathering statistics, such as total number of times each line has executed, time spent executing each line, and the minimum and maximum amounts of time spent executing a given line of code. The statistics create a “profile” for the application.
The package functions provided in DBMS_PROFILER are START_PROFILER and STOP_PROFILER. The data is collected into the tables: plsql_profiler_data, plsql_profiler_units and plsql_profiler_runs. You can use Oracle8i