V$OPEN_CURSOR

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


© Copyright SS64.com 1999-2014
Some rights reserved