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? > > > > > > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Pole nakazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx> 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-- //www.freelists.org/webpage/oracle-l