Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Last SQL Query for any User
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