8.6.1 Querying the DBMS_PROFILER Tables and View

Table of Contents Previous Next


8 Performance Analysis and Tuning : 8.6 DBMS_PROFILER : 8.6.1 Querying the DBMS_PROFILER Tables and View

(Note: the call to start_profiler() includes a comment that DBMS_PROFILER associates with the profiler session).
2.
Then call the list_emp function:
3.
Stop the profiling session with a call to dbms_profiler.stop_profiler:
4.
Start a new session with the dbms_profiler.start_profiler function (followed by a new comment):
5.
Invoke the get_dept_name function:
6.
Execute an UPDATE statement that causes a trigger to execute:
8.
Now, query the plsql_profiler_runs table to view a list of the profiling sessions, arranged by runid:
9.
Query the plsql_profiler_units table to view the amount of time consumed by each unit (each function, procedure, or trigger):
10.
Query the plsql_profiler_rawdata table to view a list of the wait event counters and wait event times:
11.
Query the plsql_profiler_data view to review a subset of the information found in plsql_profiler_rawdata table:

8 Performance Analysis and Tuning : 8.6 DBMS_PROFILER : 8.6.1 Querying the DBMS_PROFILER Tables and View

Table of Contents Previous Next