Friday, June 15, 2007

How Get Trace of a database user activity

Connect to your Sys Schema by using SQL or Toad create following trigger


Create or replace trigger APPSTRACE
after logon on apps.schema
begin
execute immediate 'ALTER SESSION SET SQL_TRACE TRUE';
end;
/

This will generate Trace for that specific session.

This is some sort of database customization that’s y I never suggest to do it with your production environment hmmm u can do it with your vision / test environment

How to remove this check from your APPS schema

alter trigger appstrace disable;