7.9 DBMS_PROFILER

Table of Contents Previous Next


7 Built-In Packages : 7.9 DBMS_PROFILER

The DBMS_PROFILER package collects and stores performance information about the PL/pgSQL and SPL statements that are executed during a performance profiling session; use the functions and procedures listed below to control the profiling tool.
For more information about the DBMS_PROFILER built-in package (including usage examples and a reference guide to the DBMS_PROFILER tables and views), see the Advanced Server Performance Features Guide.
GET_VERSION(major OUT, minor OUT)
START_PROFILER(run_comment, run_comment1 [, run_number OUT ])
The functions within the DBMS_PROFILER package return a status code to indicate success or failure; the DBMS_PROFILER procedures raise an exception only if they encounter a failure. The status codes and messages returned by the functions, and the exceptions raised by the procedures are listed in the table below.
The FLUSH_DATA function/procedure flushes the data collected in the current session without terminating the profiler session. The data is flushed to the tables described in the Advanced Server Performance Features Guide. The function and procedure signatures are:
status INTEGER FLUSH_DATA
The GET_VERSION procedure returns the version of DBMS_PROFILER. The procedure signature is:
GET_VERSION(major OUT INTEGER, minor OUT INTEGER)
The INTERNAL_VERSION_CHECK function confirms that the current version of DBMS_PROFILER will work with the current database. The function signature is:
status INTEGER INTERNAL_VERSION_CHECK
The PAUSE_PROFILER function/procedure pauses a profiling session. The function and procedure signatures are:
status INTEGER PAUSE_PROFILER
The RESUME_PROFILER function/procedure pauses a profiling session. The function and procedure signatures are:
status INTEGER RESUME_PROFILER
The START_PROFILER function/procedure starts a data collection session. The function and procedure signatures are:
status INTEGER START_PROFILER(run_comment TEXT := SYSDATE,
run_comment1 TEXT := '' [, run_number OUT INTEGER ])
START_PROFILER(run_comment TEXT := SYSDATE,
run_comment1 TEXT := '' [, run_number OUT INTEGER ])
The STOP_PROFILER function/procedure stops a profiling session and flushes the performance information to the DBMS_PROFILER tables and view. The function and procedure signatures are:
status INTEGER STOP_PROFILER

7 Built-In Packages : 7.9 DBMS_PROFILER

Table of Contents Previous Next