Your Doorstep to the Temple of Oracle

Oracle EBS

How to find the Trace file Genrated by the concurrent program

Posted by appsdba11i on May 1, 2011

How to find the Trace file Genrated by the concurrent programs in Oracle applications when Tracing is enabled as below,

Enable Trace from Sysadmin> Concurrent> Prgram> define> Query for program in the SHORTNAME
Solution
a- Enable Trace from Sysadmin> Concurrent> Program> define> Query for the SHORTNAME.

You can use the following query to locate the trace file, it takes as input the ‘ Concurrent Request id’ : .

SELECT ‘Request id: ‘||request_id ,
‘Trace id: ‘||oracle_Process_id,
‘Trace Flag: ‘||req.enable_trace,
‘Trace Name: ‘||dest.value||’/’||lower(dbnm.value)||’_ora_’||oracle_process_id||’.trc’,
–‘Prog. Name: ‘||prog.user_concurrent_program_name,
‘File Name: ‘||execname.execution_file_name|| execname.subroutine_name ,
‘Status : ‘||decode(phase_code,’R’,’Running’) ||’-‘||decode(status_code,’R’,’Normal’),
‘SID Serial: ‘||ses.sid||’,’|| ses.serial#, ‘Module : ‘||ses.module
from
fnd_concurrent_requests req,
v$session ses,
v$process proc,
v$parameter dest,
v$parameter dbnm,
fnd_concurrent_programs_vl prog,
fnd_executables execname where req.request_id = &request
and req.oracle_process_id=proc.spid(+)
and proc.addr = ses.paddr(+)
and dest.name=’user_dump_dest’
and dbnm.name=’db_name’
and req.concurrent_program_id = prog.concurrent_program_id
and req.program_application_id = prog.application_id
and prog.application_id = execname.application_id
and prog.executable_id=execname.executable_id;

b- The output would be ‘directory’/’filename.trc’
eg: ‘directory’/ora_3465_act.trc

c- In the above directory, do ‘ls -l’ for ‘*3465*trc’ and any latest file that you see with 3465 as a part of the file name would be the trace file.

d- Then disable the trace from System Administrator responsibility.

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s