Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Enterprise
Expertise: Advanced
May 16, 2000

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

Jayanta Sengupta
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.