open_cursors
Hi,
I am running the below query to see the current open_cursors in my one of the databases.
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;
max_open_cur is keep on increasing and some times application are hitting ORA-1000. When I talked with developers they obviously says they are closing all the cursors.
I have tried with SQLNET.EXPIRE_TIME=10 but that is not useful.
Can some one suggest me a way to close the open_cursors by adding any parameter in sqlnet.ora or listener.ora? Appreciate your help.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.