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: Last SQL Query for any User

Re: Last SQL Query for any User

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 22 May 2003 21:22:14 +0800
Message-ID: <3ECCCF06.152B@yahoo.com>


Alex Smith wrote:
>
> How can we get the Query that was last executed by a User.
>
> For TOAD users - "Kill / Trace Session" gives this ability to monitor all
> activities and see SQL query executed last for any user.
>
> How can I accomplish this by linking
>
> V$SESSION, V$SQLAREA or V$SQLTEXT

Check the SQL_ADDRESS column - links from v$session to v$sql et al

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"
Received on Thu May 22 2003 - 08:22:14 CDT

Original text of this message

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