Re: How to obtain number of opened cursors from any opened session

From: Bhooshan S. Prabhu <bhooshan.prabhu_at_citicorp.com>
Date: 3 Jul 2001 23:30:03 -0700
Message-ID: <2cf4efe2.0107032230.468e9e86@posting.google.com>

"Olek" <alexme_at_aptus.pl> wrote in message news:<3b41da32$1_at_news.vogel.pl>...
> I would like to get the number of curently opened cursors by any active
> session.
> Is any dynamic V$ view from where I can obtain this info, or mayby any other
> way ?
> I know V$SESSION_CURSOR_CACHE but it applays only to session opened by me.
>
> Thanks in advance
> Alex

---

V_$OPEN_CURSOR shall give you what you are looking for.

Regards
Bhooshan Received on Wed Jul 04 2001 - 01:30:03 CDT