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: Burt Peltier <burttemp1REMOVE_THIS_at_bellsouth.net>
Date: Thu, 22 May 2003 22:59:03 -0500
Message-ID: <%Ugza.10586$V6.1704@fe03.atl2.webusenet.com>


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...

> 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
>
>
Received on Thu May 22 2003 - 22:59:03 CDT

Original text of this message

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