ORA-1000 : max open cursors exceeded
when calling some specific application logic, the number of open_cursors ORA-1000 : max open cursors exceeded. is increased with one.
select a.value, s.sid
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'
We would like to know which SQL is behind ...
Any idea how to identify such statement ?
Thanks in Advance,
Dina
select a.value, s.sid
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'
We would like to know which SQL is behind ...
Any idea how to identify such statement ?
Thanks in Advance,
Dina
0