查看并发请求的trace file

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 || '_ANONYMOUS.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_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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10359218/viewspace-750490/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10359218/viewspace-750490/