curs

SELECT s.sid, s.serial#, COUNT(*) cursors
FROM v$open_cursor c
JOIN v$session s ON s.sid = c.sid
GROUP BY s.sid, s.serial#
ORDER BY cursors DESC;


SELECT sql_text, COUNT(*)
FROM v$open_cursor
GROUP BY sql_text
ORDER BY COUNT(*) DESC;