Re: viewing open cursors

From: <kal121_at_my-deja.com>
Date: 2000/06/19
Message-ID: <8ili2k$o9r$1@nnrp1.deja.com>#1/1

Yep, that's what I meant when I referred to v$cursor below, my mistake. v$open_cursor does give real time information, but what if the cursor closes before you can query the table?

In article <961181218.29.2.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> You are aware of v$open_cursor?
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <kal121_at_my-deja.com> wrote in message

news:8idp4t$1mm$1_at_nnrp1.deja.com...
> > Hello,
> >
> > Is there a way to view open cursors REAL time? I'd like to see what
> > cursors are being opened as a certain application runs.
> >
> > Obviously, querying the v$cursor table after the fact will not give
me
> > what I need, as the cursors will then be closed.
> >
> > Is there some sort of tool out there that can display this
information
> > graphically? Quest?
> >
> > Thanks
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jun 19 2000 - 00:00:00 CDT