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: Any way to get the last SQL statement?

Re: Any way to get the last SQL statement?

From: Rognvald Bjarne <wear_u_out_at_nospam.hotmail.com>
Date: Thu, 17 Aug 2000 08:12:49 -0600
Message-ID: <MpSm5.4817$XUq6.36307407@news.randori.com> 






Closest I can get is to see which ones are "active" by linking v$sqltext or
v$sqlarea with v$session; this'll be interesting to see if someone finds
what you're looking for though.



"Kit" <pashwawa_at_hotmail.com> wrote in message
news:8nft9v$o3f29_at_imsp212.netvigator.com...


> I need to get the last SQL statement performed by Oracle.  Can it be

> retrieved from the system tables?

>

> Thanks.

>

>

Received on Thu Aug 17 2000 - 09:12:49 CDT












Original text of this message













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