This dump was introduced in Oracle 10.2 though it is reported to be unstable in early versions of that release.
To dump cursors currently stored in the SGA use:
CURSORDUMP <level>
where level is:
| Level | Description |
| 1 | Dump all open / cached cursors for current session |
| 2 | Dump all open / cached cursors in the library cache |
For example:
ALTER SESSION SET EVENTS 'immediate cursordump(1)';
Alternatively use ORADEBUG. For example:
ORADEBUG DUMP CURSORDUMP 1
For addtional information see:
ORADEBUG DOC EVENT ACTION CURSORDUMP