Maximum open cursors exceeded
会话已超过 OPEN_CURSORS 参数限制,同时打开了太多游标。
SHOW PARAMETER open_cursors;SELECT sid, COUNT(*) AS cursor_count FROM v$open_cursor GROUP BY sid ORDER BY 2 DESC FETCH FIRST 10 ROWS ONLY;SELECT s.sid, s.username, COUNT(*) AS cnt FROM v$open_cursor oc JOIN v$session s ON oc.sid = s.sid GROUP BY s.sid, s.username ORDER BY cnt DESC;