Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to count CURRENTLY OPENED CURSORS?

Re: How to count CURRENTLY OPENED CURSORS?

From: <rdong_at_my-deja.com>
Date: Thu, 09 Nov 2000 15:48:23 GMT
Message-ID: <8ueh04$u6f$1@nnrp1.deja.com> 






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.
Received on Thu Nov 09 2000 - 09:48:23 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US