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;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s