SQL Text

Overview

The SQL Text report displays in real-time the performance data in the SQL Text and Explain Plan fields. This is a drilldown report.

Note:
Do not use this report alone. This report is displayed in a drilldown from the Open Cursors report or Session Detail(5.0) report.

Storage location

Reports/RM Oracle/Troubleshooting/Real-Time/Drilldown Only/

Record

SQL Text (PD_PDSQ)

Fields

Field nameDescription
Explain PlanExecution plan on the SELECT, UPDATE, INSERT, and DELETE statements selected by the Oracle optimizer.
SQL TextPart of the SQL text