DBA Profiler Data – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

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;

Report Parameters

Run Id, Module, Time From, Percentage From, Line Text Contains, Line Number From, Line Number To, Time Unit

Oracle EBS Tables Used

plsql_profiler_runs, plsql_profiler_units, plsql_profiler_data

Report Categories

Enginatics

DBA AWR SQL Performance Summary, DBA SGA Blocking Session Summary, DBA AWR Blocking Session Summary, DBA AWR Active Session History, DBA SGA Active Session History, FND Concurrent Requests 11i, FND Concurrent Requests, DBA ORDS Configuration Validation

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output DBA Profiler Data 14-Dec-2025 081549.xlsx
Blitz Report™ XML Import DBA_Profiler_Data.xml
Full SQL on Enginatics www.enginatics.com/reports/dba-profiler-data/

© 2026 Enginatics