Performance Analysis of Application by Code Profiling

Performance Analysis of Application by Code Profiling

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

See also  Why ChatGPT Is So Important Today

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist