DBA Profiler Data

Description

Categories
Enginatics, R12 only
Repository
GitHub
Excel version of Oracle's dbms_profiler PLSQL performance analysis, see Oracle note:
Using DBMS_PROFILER (KB85737)
https://support.oracle.com/support/?kmContentId=97270

PL/SQL units that have been compiled in NATIVE mode cannot be profiled using the DBMS_PROFILER package.
To gather information using DBMS_PROFILER, you must ensure that the PL/SQL code is INTERPRETED."
Before compilation of the profiled code, execute:
alter session set plsql_code_type=interpreted;

To start and stop profiling code, use the following commands (see use https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_profil.htm#i1000047):
dbms_profiler.start_profiler(optional run_comment);
dbms_profiler.stop_profiler;

To purge and reset the profiler data, execute the following as sys:
truncate table sys.plsql_profiler_data;
truncate table sys.plsql_profiler_units;
truncate table sys.plsql_profiler_runs;
alter sequence plsql_profiler_runnumber restart start with 1;

SQL 36 lines

Parameters 8

ParameterTypeList of values SQL
Run IdLOV
ppr.runid=:runid
ModuleLOV
ppu.unit_owner=substr(:unit_name,1,instr(:unit_name,'.')-1) and
ppu.unit_name=substr(:unit_name,instr(:unit_name,'.')+1)
Time FromNumber
x.time>:time_from
Percentage FromNumber
x.percentage>:percentage_from
Line Text ContainsChar
lower(x.line_text) like '%'||lower(:line_text_contains)||'%'
Line Number FromNumber
ppd.line#>=:line_from
Line Number ToNumber
ppd.line#<=:line_to
Time UnitLOV