找request的Trace文件

select 'Trace Name: '|| dest.value || '/' || lower(dbnm.value) || '_ora_' ||

oracle_process_id || '.trc',

'File Name: ' || execname.execution_file_name,

execname.subroutine_name

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 = 432566 --1189641

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