REQUEST的TRACE文件

--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