--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 1 = 1
AND REQ.REQUEST_ID = &REQUEST_ID --parameters
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