Open Cursors

Overview

The Open Cursors report displays in real-time a cursor opened by a session. This is a drilldown report.

Storage location

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

Record

Open Cursor (PD_PDOC)

Fields

Field nameDescription
AddrhashCharacter string that identifies the SQL statement being executed
ProgramName of the program being executed
SIDSession ID
SQL TextFirst 60 characters of the SQL statement that was analyzed by the open cursor. To display the SQL Text report, choose this field.
UserOracle user name

Drilldown reports (report level)

Report nameDescription
SQL TextDisplays the performance data in the SQL Text and Explain Plan fields. To display this field, choose the SQL Text field.