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: "latest sql"?

Re: "latest sql"?

From: Fred <fredericpied_at_wanadoo.fr>
Date: Sat, 14 Dec 2002 12:05:58 +0100
Message-ID: <atf3ap$ki5$1@news-reader12.wanadoo.fr>


Try a select un the V$SQLAREA Dynamic vue... You can join it with V$SESSION

--
--------
"CoolDude" <nospam_at_nospam.it> a écrit dans le message de news:
M6xK9.109733$Q71.83481_at_news01.bloor.is.net.cable.rogers.com...

> Question: how to find out the latest sql executed on a given session id?
> assuming audit is turned off.
>
> Thanks!
>
> -cd
>
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.427 / Virus Database: 240 - Release Date: 06/12/2002
Received on Sat Dec 14 2002 - 05:05:58 CST

Original text of this message

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