RE: Number of open cursors

From: Linda Hagedorn <Linda_at_pets.com>
Date: Wed, 30 Aug 2000 11:42:09 -0700
Message-Id: <10604.115900@fatcity.com>

Hi Brian,

Thanks very much for the reference. I'll add the query to my monitor script.

Regards, Linda

-----Original Message-----
From: Anderson, Brian [mailto:andersob_at_mail.dartnet.peachnet.edu] Sent: Wednesday, August 30, 2000 12:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Number of open cursors

Try this to see how many you have per session.

select SID, count(sid) from v$open_cursor group by sid;

We used to have cursor troubles, and we ended up with OPEN_CURSORS of 1024. Received on Wed Aug 30 2000 - 13:42:09 CDT