|
V$OPEN_CURSOR
Data Dictionary ViewColumns ___________________________ SADDR SID USER_NAME ADDRESS HASH_VALUE SQL_TEXT
The Init.ora parameter OPEN_CURSORS sets the limit of open cursors *per session*.
V$OPEN_CURSOR holds the information of all open cursors instance-wide.
To check if you are near the OPEN_CURSORS limit, try the following query:
SELECT
sid, user_name, COUNT(*) "Cursors per session"
FROM v$open_cursor
GROUP BY sid, user_name;
Related:
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