Re: Number of Open Cursors

From: Thomas A. La Porte <tlaporte_at_anim.dreamworks.com>
Date: 18 May 1999 16:09:24 GMT
Message-ID: <7hs3bk$pl2$1@fir.prod.itd.earthlink.net>

You can issue the following query for a particular session, given the sid of the session:

select sum(decode(sn.name,'opened cursors current',se.value)) "Current Cursors" from v$sesstat se, v$statname sn
where se.statistic# = sn.statistic#
and se.sid = :sid

In article <373C5122.D8D053EE_at_bentley.com>, Tom Best <tom.best_at_bentley.com> wrote:
>Is there a way to determine the number of open cursors in a particular
>DB connection? I'm using OCI.
>
>Thanks.
>Tom Best
Received on Tue May 18 1999 - 11:09:24 CDT