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:V$Session V$SQL V$SQLAREA V$SQLTEXT V$SQLTEXT_WITH_NEWLINES V$SQLXS V$SQL_BIND_DATA V$SQL_BIND_METADATA V$SQL_CURSOR V$SQL_PLAN V$SQL_PLAN_STATISTICS V$SQL_PLAN_STATISTICS_ALL V$SQL_REDIRECTION V$SQL_SHARED_CURSOR V$SQL_SHARED_MEMORY V$SQL_WORKAREA V$SQL_WORKAREA_ACTIVE V$SQL_WORKAREA_HISTOGRAM