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.

Did anyone meet the same behaviour?


Code:
SQL*Plus: Release 10.2.0.3.0 - Production on Fri Sep 5 12:20:23 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining, Oracle Database Vault and Real Application Testing options


Session altered.

12:20:23 > connect user/user@DUBRAC1
Connected.

Session altered.

Elapsed: 00:00:00.00
12:20:35 > EXEC DBMS_STATS.gather_schema_stats (ownname => 'USER', cascade =>true,estimate_percent => dbms_stats.auto_sample_size
);
BEGIN DBMS_STATS.gather_schema_stats (ownname => 'USER', cascade =>true,estimate_percent => dbms_stats.auto_sample_size); END;

*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded


Elapsed: 00:24:34.30
12:45:41 > analyze table ACCOUNT_POSTING comute statistics cascade constraint;
analyze table ACCOUNT_POSTING comute statistics cascade constraint
                              *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01490: invalid ANALYZE command


Elapsed: 00:00:00.01