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