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