Troubleshooting Open Cursor Issues - ORA-01000: maximum open cursors exceeded
Troubleshooting Open Cursor Issues - ORA-01000: maximum open cursors exceeded Find out the session that is causing the error by using the following SQL statement: select a.value, s.username, s.sid, s.serial# from v$sesstat a, v$statname b, v$session s where a.statistic# = b.statistic# and s.sid=a.sid and b.name = 'opened cursors current' and s.username is not null; The output displays the details of all sessions. You can see the maxed out session IDs. To display which queries are causing maxing out of open cursors, run the following SQL statement: set lines 200 col USER_NAME FOR A40 select sid ,USER_NAME,sql_text, count(*) as "OPEN CURSORS" from v$open_cursor where sid in (&SID) group by sid ,USER_NAME,sql_text ; set lines 200 col USER_NAME FOR A40 select sid ,USER_NAME,sql_text,sql_id, count(*) as "OPEN CURSORS" from v$open_cursor where sid in (&SID) group by sid ,USER_NAME,sql_text,sql_id ; The top queries that are opening maximum cursors and ar...