Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Last SQL Query for any User
Why not just turn on the "spool to screen" option in TOAD and see what it
runs ?
-- "Alex Smith" <SorryNoSpam_at_Please.Com> wrote in message news:cl2za.2762$Pz3.1280396_at_news4.srv.hcvlny.cv.net...Received on Thu May 22 2003 - 22:59:03 CDT
> 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
>
>