Oracle Database Discussions

Hello fellows,
People here were trying to run a process in webserver, and then it returned an error: ORA-0100 open cursors exceeded.

show parameter open_cursors
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 5000


Then i search about it, and ran this query to check who is consuming a lot of cursors:





select a.value, s.username, s.sid, s.serial#
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic#
and s.sid = a.sid
and b.name = 'opened cursors current'
and s.username is not null order by 1 desc;

VALUE USERNAME SID SERIAL#
---------- ------------------------------ ---------- ----------
2830 ISSR 877 12351
213 ISSR 692 43434
68 ISSR 918 15447


We have a lot more users, but i've shown only this 3.

My question here is: Can i manually close open cursors? What would be the impact in the database ?

It is in a production database, and the other dba just raised the open_cursors from 3500 to 5000, worked for now, but when the open_cursors get in 5000 again, it would be a problem.


Thanks in advance.