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

From: Chuck Hamilton <chuck_hamilton_at_hotmail.com>
Date: Tue, 3 Jul 2001 11:03:44 -0400
Message-ID: <9hsmsj$foroc$1@ID-85580.news.dfncis.de>

Try v$open_cursor.

"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
>
>
>
>
Received on Tue Jul 03 2001 - 10:03:44 CDT

This message: [ Message body ]
Next message: Chris Weiss: "Re: Deadlocks"
Previous message: Chuck Hamilton: "Deadlocks"
In reply to: Olek: "How to obtain number of opened cursors from any opened session"
Next in thread: Thomas Kyte: "Re: How to obtain number of opened cursors from any opened session"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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