I am running the below query to see the current open_cursors in my one of the databases.
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.
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;
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.
Try hard to get what you like OR you will be forced to like what you get.
Click Here to Expand Forum to Full Width