PL/SQL Packages DBMS_PROFILER

Profile existing PL/SQL applications to identify code coverage and determine performance bottlenecks.

Subprocedures:

START_PROFILER Function
                 Start profiler data collection in the user's session. 

STOP_PROFILER Function
                 Stop profiler data collection in the user's session. 

FLUSH_DATA Function
                 Flush profiler data collected in the user's session. 

PAUSE_PROFILER Function
                 Pause profiler data collection. 

RESUME_PROFILER Function
                 Resume profiler data collection. 

GET_VERSION      Get the version of this API. 

INTERNAL_VERSION_CHECK Function
                 Verify that this version of the DBMS_PROFILER package
                 can work with the implementation in the database.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

Related Commands:

Related Packages: