Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference


SQL Text

Organization of this page

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