How to get trace file for concurrent request id
SELECT
req.request_id
,req.logfile_node_name node
,req.oracle_Process_id
,req.enable_trace
,dest.VALUE||'/'||LOWER(dbnm.VALUE)||'_ora_'||oracle_process_id||'.trc' trace_filename
,prog.user_concurrent_program_name
,execname.execution_file_name
,execname.subroutine_name
,phase_code
,status_code
,ses.SID
,ses.serial#
,ses.module
,ses.machine
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 1=1
AND req.request_id = &request --Request ID
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
Thanks
Srini
This blog post is incredibly insightful for anyone looking to understand how to generate trace files for concurrent processes in Oracle EBS. The step-by-step guide is thorough and easy to follow, making it a valuable resource for troubleshooting and system optimization. The detailed explanations of the processes not only help clarify potential issues but also empower users to manage their system performance more effectively. Additionally, for those who are involved in both technical and creative projects, you might find it beneficial to explore clipping path service india to enhance your visual content with high-quality editing. Keep up the great work and thanks for sharing such practical advice!
ReplyDelete