Database Administration (MOSC)

MOSC Banner

ORA-01000 in webapp despite number of open cursors nowhere near open_cursors

edited Dec 23, 2014 11:16AM in Database Administration (MOSC) 9 commentsAnswered

Hi,

A webapp uses a connection pool (c3p0) to connect to an 11.2.0.3 EE database.

I monitor the number of open cursors per session with a pair of queries that run in a cron job every minute:

select max(a.value) as highest_open_cur
from v$sesstat a, v$statname b
where a.statistic# = b.statistic#
and b.name = 'opened cursors current';

and

select max(count(oc.sql_id))
from v$OPEN_CURSOR oc, v$session se
where oc.sid = se.sid
group by oc.sid, oc.USER_NAME
order by count(*) desc;

The webapp gets fairly regular ORA-01000 errors.

Tagged:

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