Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Auditing
Nop. You sql is not recorded, however you can audit table access, and
statement types, or you can use available monitoring tools to watch for
active sessions and capture their sql. I am using a tool called dbTools
for both sorts of tasks mentioned above. It also includes a GUI tool for
the auditing, kinda of click, click, click, you don't have to remember
sql syntax and oracle table names. http://www.softtreetech.com/monitor
Regards,
Dev
In article <8bfule$40a$1_at_pegasus.tiscalinet.it>,
"Food" <Food_at_flashnet.it> wrote:
> hi all,
> I've got a database in AUDIT_TRAIL .....
> Exist a table or view where I can see the statements of a session ?
>
> For example :
> insert into table1
> select * from table2
> where field = '3';
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Mar 24 2000 - 00:00:00 CST