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 can I monitor open cursors?

Re: How can I monitor open cursors?

From: <ngroves_at_ndsuk.com>
Date: Wed, 19 May 1999 16:40:15 GMT
Message-ID: <7huphf$9cs$1@nnrp1.deja.com>


In article <37416D93.D8BA28D0_at_md.pp.ru>,   Dmitri Maximovich <maxim_at_md.pp.ru> wrote:
>
> How can I monitor open cursors, i.e. get information how many cursors
> open so far, etc.
> Maybe this information stored in some system table?
>
> Thanks.

Have a look at v$open_cursors - that ought to do it:-) nigel groves

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 19 1999 - 11:40:15 CDT

Original text of this message

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