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

Last SQL Query for any User

From: Alex Smith <SorryNoSpam_at_Please.Com>
Date: Thu, 22 May 2003 11:17:28 GMT
Message-ID: <cl2za.2762$Pz3.1280396@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 - 06:17:28 CDT












Original text of this message













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