Information about all open cursors, instance-wide.
Columns ___________________________ SADDR SID USER_NAME ADDRESS HASH_VALUE SQL_TEXT
To check the number of cursors opened per session, try the following query:
SELECT
sid, user_name, COUNT(*) "Cursors per session"
FROM v$open_cursor
GROUP BY sid, user_name;
Related:
The Init.ora parameter OPEN_CURSORS sets the limit of open cursors *per session*.
V$SQL V$SQLAREA V$SQLTEXT V$SQLTEXT_WITH_NEWLINES V$SQL_BIND_DATA V$SQL_BIND_METADATA V$SQL_CURSOR V$SQL_SHARED_MEMORY