My Oracle Support Banner

DBMS_PROFILER does not Return Detailed Information (Doc ID 602711.1)

Last updated on MARCH 26, 2019

Applies to:

PL/SQL - Version and later
Information in this document applies to any platform.
***Checked for relevance on 26-Mar-2019***


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.




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

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