Open Cursors
- Organization of this page
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 name |
Description |
|---|---|
|
Addrhash |
Character string that identifies the SQL statement being executed |
|
Program |
Name of the program being executed |
|
SID |
Session ID |
|
SQL Text |
First 60 characters of the SQL statement that was analyzed by the open cursor. To display the SQL Text report, choose this field. |
|
User |
Oracle user name |
Drilldown reports (report level)
|
Report name |
Description |
|---|---|
|
SQL Text |
Displays the performance data in the SQL Text and Explain Plan fields. To display this field, choose the SQL Text field. |