Re: How to count CURRENTLY OPENED CURSORS?

From: David Fitzjarrell <oratune_at_aol.com>
Date: Thu, 09 Nov 2000 22:00:25 GMT
Message-ID: <8uf6pk$ip8$1@nnrp1.deja.com>

In our last gripping episode rdong_at_my-deja.com wrote:
> In article <8ud33v$bfl$1_at_secondhat.secondhat.com>,
> <dominica_at_secondhat.com> wrote:
> >
> > Hi All,
> >
> > What is the BEST way to count opened cursors currently?
> > (this is talking about Oracle Server 8.1.5 on solaris platform)
> > Please email me directly to:
> >
>
> What is the purpose of your query? The init.ora
> parameter "open_cursors" is the maximum number of open cursors per
> session and not the maximum for the instance.
>
> http://members.home.com/rdong
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Does it really matter WHY she is asking her question? And why didn't you email this query to her directly, as she asked? Apparently she didn't want to wait in the newsgroup for a response.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Thu Nov 09 2000 - 16:00:25 CST