Re: application sql auditting

From: Tom Best <tom.best_at_bentley.com>
Date: Thu, 27 May 2004 12:55:41 -0400
Message-ID: <c955fc$kdv$1@news.bentley.com>

You could collect trace data. The smoothest way would probably be to turn it on in a logon trigger so it's always on for that app userid.

create or replace trigger logon_trigger after logon on database
begin
  if (user = 'YOUR_APP_USERID' and module = 'the_app_name.exe') then    execute immediate 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT FOREVER, LEVEL 4''';
  end if;
  exception
  when others then
   null;
end;

Tom Best

"Andrew" <myfam_at_surfeu.fi> wrote in message news:c5826e91.0405270721.46274d5_at_posting.google.com...
> Hi,
> I need to audit sql from application which sits on the same unix host
> and uses vortex.
> What is the simplest way to see which SQL is being sent from
> application for ORACLE when application performs sertain database
> actions?
>
> Application is in compiled binary format there is no logging level
> which will force it to log SQL.
>
> Thanks,
> Andrew
Received on Thu May 27 2004 - 11:55:41 CDT