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 determine the number of opened cursors

RE: How to determine the number of opened cursors

From: Totx <zunda_at_softhome.net>
Date: Mon, 22 Oct 2001 11:40:02 -0500
Message-ID: <9r0p9s$k4q2@tid.tid.es>


Hi!

Look into v$open_cursors view.

Markus Boehmer <markus.boehmer_at_schaefer-shop.de> escribió en el mensaje de noticias 3BD3E64E.4090202_at_schaefer-shop.de...
> Hi guys and gals,
>
> does anyone knows a way in oracle to find out how many cursors are open
> at a time?
>
> I only know "show parameter cursor" which shows me the number of allowed
> open cursors.
>
> Greetings
> Markus
> --
> Markus Böhmer
> Datenbankentwickler
> SSI Schäfer Shop GmbH
> mailto:markus.boehmer_at_schaefer-shop.de
>
Received on Mon Oct 22 2001 - 11:40:02 CDT

Original text of this message

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