DBMS_PROFILER does not Return Detailed Information
(Doc ID 602711.1)
Last updated on AUGUST 30, 2017
Applies to:PL/SQL - Version 188.8.131.52 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!