Maximum open cursors
705881Nov 17 2009 — edited Nov 24 2009hi 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