Re: Currently executing SQL

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Sun, 27 Jun 1999 14:44:27 -0400
Message-ID: <3776710B.A5FA7FCE@bigfoot.com>

That works well. Just for jollies...any explanation of what these two join
columns mean? I assume that sql_hash has something to do with hashing by
the parser to indicate where the sql_statement is, (right, wrong?), how about
sql_address?

John Higgins wrote:

> Just join v$session and v$sqltext on sql_address and sql_hash value.
>
> Doug Cowles wrote:
>
> > Does anyone have a quick way to find what SQL a user is currently
> > executing?
> > I've been a little spoiled by tools lately.
> >
> > - Dc.
Received on Sun Jun 27 1999 - 13:44:27 CDT