Re: Oracle Session commands

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Tue, 6 Dec 2011 16:01:10 +0100
Message-ID: <4EDE2E36.2070308_at_nordea.com>

You could use FGA to audit, but the least problematic is sql_trace or setting event 10046 in such session

W dniu 06.12.2011 15:50, Terrian, Thomas J DLA CTR TRANSACTION SERVICES pisze:
> Oracle 10g.
>
> Is there any view in Oracle that records all of the commands that came
> from a session? For example, if I have a session that has been open for
> an hour, I would like to see something like:
>
> SID Time Command
> 123 8:00 Desc emp;
> 123 8:10 Select * from emp;
> 123 8:20 Insert ....into emp;
> ....
>
> Is there any V$ that I can select from to get this information?
>
>
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Pole nakazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, 
dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, 
VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, 
o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, 
NIP: 586-000-78-20, REGON: 190024711--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 06 2011 - 09:01:10 CST