DBMS_PROFILER does not Return Detailed Information

(Doc ID 602711.1)

Last updated on AUGUST 30, 2017

Applies to:

PL/SQL - Version 9.2.0.8 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Aug-2017***

Symptoms

The PL/SQL package DBMS_PROFILER does not report detailed information in table plsql_profiler_data.  It only provides one line containing the total time taken by the code.  It should provide information on the total number of times each line has been executed, the total amount of time that has been spent executing that line and the minimum and maximum times that have been spent on a particular execution of that line.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms