From: "Alexey E. Neckrasow" <nec@leaves.spb.su>
Subject: Re: Cursor Count Question
Date: 1997/08/08
Message-ID: <33EB07D1.DD54C022@leaves.spb.su>#1/1
References: <01bca1bc$99e0c760$f80000c0@steve.evans.foundationsystems.co.uk>
To: Jonathan Atkinson <jonathanatkinson@foundationsystems.co.uk>
X-Priority: 3 (Normal)
Organization: Leaves Inc.
Reply-To: nec@leaves.spb.su
Newsgroups: comp.databases.oracle.server



Hi!

Try v$open_cursor view.

Jonathan Atkinson wrote:

> Hello,
>
> If V$SESSION shows the connected users where can I look to find the
> number
> of open CURSORS?
>
> Rgds,
>
> Jonathan A.
> London, UK



--
Regards. Alexey Neckrasow. Leaves Inc. Russia.
e-mail: nec@leaves.spb.su