![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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. |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.