Database Administration (MOSC)

MOSC Banner

ORA-1000 : max open cursors exceeded

edited Jan 20, 2011 12:06AM in Database Administration (MOSC) 4 commentsAnswered ✓
 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
 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center