Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "latest sql"?
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...Received on Sat Dec 14 2002 - 05:05:58 CST
> 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