Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Currently executing SQL

Re: Currently executing SQL

From: John Higgins <JH33378_at_deere.com>
Date: Sat, 19 Jun 1999 21:08:11 -0500
Message-ID: <376C4D0A.2551490F@deere.com>


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 Sat Jun 19 1999 - 21:08:11 CDT

Original text of this message

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