SQL Text

Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference

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 name	Description
Explain Plan	Execution plan on the SELECT, UPDATE, INSERT, and DELETE statements selected by the Oracle optimizer.
SQL Text	Part of the SQL text