ORA-01000: Maximum Open Cursors Exceeded in Oracle - Complete Fix Guide
Error ORA-01000: Maximum Open Cursors Exceeded Applies to: Oracle Database 11.2.0.4 Description: We are facing the error “ora-01000: maximum open cursors exceeded” on our production database server. The error is related to cursor limit, open_cursors exceeding its default value. Solution: To fix the issue we can either kill the inactive sessions which have open the large number of cursors or increase the value of open_cursors. To check the open_cursors limit: Execute the following query to list the top 10 sessions which are currently opening most cursors: SQL> select * from(select sess.sid, stan.name, sess.value from v$sesstat sess, v$statname stan where sess.statistic# = stan.statistic# and stan.name like ‘%opened cursors current%’ order by desc 3) where rownum < 11; Now we check the detail of above se...