If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

RAC 11g: ORA-01000: maximum open cursors exceeded

Hi All,

We have Oracle RAC on Oracle Enterpise Linux.
And very often we get error: ORA-01000: maximum open cursors exceeded
We were gitting it more often when we had cursor_sharing=exact
Currently it is set to simmilar
It does not matter what application we use, the example bellow is very demonstrative as this is a new session and only collect statistics were running.

The problem is that our application works fine with 10g,
with RAC 11i - even dbms_stats does not work (see provided code).
We have a standaolne version of Oracle 11i and application works fine, but does not work with RAC of the sam eversion. I assume there is something wrong related to RAC.

Thank you, but our application does not start to open more cursors, more over Standalone version of Oracle 11i with 300 sursors works fine.
In my first post you can see that even dbms_stats fails to run.

Thank you, but our application does not start to open more cursors, more over Standalone version of Oracle 11i with 300 sursors works fine.
In my first post you can see that even dbms_stats fails to run.

But if it is interfering with users on a production database then set it to 2000 if that is what needed, and then see how many you are using and whether you can rewrite your code to be more efficient in closing cursors. You could wonder why 600 isn't enough, or you could just deal with it and try to improve the situation once you have it stabilized.