How to enable trace in User level in R12.2

Step 1: Go to system administratoràProfileàsystem

Enter username and Profile Option “Initialization SQL Statement – Custom” and search





Step 2: Just replace the User for below command and paste the command

 

Begin fnd_ctl.fnd_sess_ctl('','','TRUE','TRUE','LOG','ALTER SESSION SET TRACEFILE_IDENTIFIER='||''''||<Username>||''''||' EVENTS='||''''||'10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'||'''');End;

 

Example:

Begin fnd_ctl.fnd_sess_ctl('','','TRUE','TRUE','LOG','ALTER SESSION SET TRACEFILE_IDENTIFIER='||''''||Sanjeev||''''||' EVENTS='||''''||'10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'||'''');End;


Trace File Location:

set line 1000

SQL> select * from v$diag_info;

Comments

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to clear weblogic stuck threads in R12.2