Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Maximum open cursors

705881Nov 17 2009 — edited Nov 24 2009
hi to all,

i have got a error as java.sql.SQLException: ORA-01000: maximum open cursors exceeded
By default in init.ora file it would be open_cursors=300. Now i have changed to 1000 by using the below query.

ALTER SYSTEM SET open_cursors =1000 SCOPE=BOTH;

The above query reflected in the oracle db and i confirmed by executing the below query.

select max(a.value) as highest_open_cur, p.value as max_open_cur
from v$sesstat a, v$statname b, v$parameter p
where a.statistic# = b.statistic#
and b.name = 'opened cursors current'
and p.name= 'open_cursors'
group by p.value;

But when i start my application once it attain the open_cursors=300, its says maximum open cursors exceeded,
i got the same error though i have increased the open cursors value.

Please suggest me for further proceedings.
thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2009
Added on Nov 17 2009
6 comments
2,590 views