The Profiling Results tab provides a summary of the profiling information for all the objects, grouped by type, that have been executed within
the database since you started procedure profiling. The information displayed includes:
Column
Description
Name
The name of the object.
Owner
The owner of the object.
Table or Table Name
The table a trigger belongs to (this column only appears on the database Profile tab).
Event
The type of object, for example, a procedure.
Type
The type of trigger for system triggers. This can be Update or Delete.
# Execs.
The number times each object has been called.
# msec.
The total execution time for each object.
These columns, and their content, may vary depending on the type of object.
When you double-click a specific object, such as a procedure, details specific to that object appears in the Profiling Results tab. The information displayed includes:
Column
Description
Execs
The number of times the line of code in the object was executed.
Milliseconds
The total amount of time that a line took to execute.
%
The percent of total time that a line took to execute.
Line
The line number within the object.
Source
The code that was executed.
Lines with long execution times compared to other lines in the code should be analyzed to see whether there is a more efficient
way to achieve the same functionality. You must be connected to the database, have profiling enabled, and have DBA authority
to access procedure profiling information.
How to read procedure profiling results