DBMS_PROFILER does not Return Detailed Information
Last updated on AUGUST 30, 2017
Applies to:PL/SQL - Version 22.214.171.124 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Aug-2017***
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.
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