My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.