Database Reference
In-Depth Information
SELECT dbms_sqltune.report_sql_monitor(sql_id => '5kwfj03dc3dp1',
type => 'active')
FROM dual
In most situations, the report provides all the information you need to understand how a specific execution
was carried out. For an active report (note that the formats
text
and
html
provide less information), the following
information is provided:
•
General information about the execution, as well as a summary of key performance figures
(Figure
4-11
)
Figure 4-11.
Overview information about a monitored operation
•
The execution plan, including performance figures at the operation level (Figure
4-12
)
Figure 4-12.
Execution plan of a monitored operation