RE: Number of open cursors

I'd like to include the dynamic cursor counts since they count against open_cursors.

I set Brians query to report the sessions with more than 20 open cursors.

select SID, count(sid)
from v$open_cursor
group by sid
having count(sid) > 20
order by 2 desc ;

Any ideas on how to get the total number of open cursors, dynamic included, for a session?

Thanks, Linda

-----Original Message-----
From: K Gopalakrishnan [mailto:kaygopal_at_yahoo.com] Sent: Wednesday, August 30, 2000 1:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: Number of open cursors

Hi !

THe better picture can be obtained from
V$SYSSTAT because V$OPEN_CURSORS
will not inlde the dynamic cursor stats

SELECT name,value from V$sysstat
where name like '%cursor%;

K Gopalakrishnan Received on Wed Aug 30 2000 - 14:21:44 CDT