Home > Oracle > ORA-1000: Maximum open cursors exceeded

ORA-1000: Maximum open cursors exceeded

–who has how many cursors open?


select a.osuser,  a.sid,a.username, a.machine, count(*) from
v$session a, V$OPEN_CURSOR b
where a.sid  =  b.sid
group by
a.osuser, a.sid, a.username,a.machine
order by count(*) desc;

Monitoring Open and Cached Cursors on OraFAQ.com

Advertisements
Categories: Oracle
  1. The Boss
    February 11, 2010 at 4:01 pm

    Your link doesn’t work correctly

  2. mikey
    February 11, 2010 at 4:23 pm

    Thanks Sorted it out

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: