Re: Polling SQL Queries

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Sat, 13 Sep 2003 15:01:08 GMT
Message-ID: <UiG8b.2529$1D5.1650@nwrddc02.gnilink.net>

"KJD" <kjdama_at_yahoo.com> wrote in message news:8c907343.0309130603.4fe1a516_at_posting.google.com...
> >
> >
> > v$sqlarea captures the number of executions.
> > The problem with your approach is that tools like you propose to
> > develop usually impose a significant overhead on the database.
> > You would also better use statspack as it is already capable of
> > tracking sql.
> >
> >
>
> At any one point in time can I query Oracle for what SQL queries it is
> executing at this very point in time. There must be a way to tell me
> what Oracle is busy doing at any point in time.

ok . a hint: v$session has a status 'ACTIVE' and then it has the column 'sql_address'.
The view v$sqltext_with_newlines has a column sql_address. You would need to do some filtering of the data returned.

Now, understand that it is a very *expensive* query for the database.

So meant to be used sparingly!

Anurag Received on Sat Sep 13 2003 - 10:01:08 CDT