Oracle EBS - SQL&PL/SQL: 根据request id找trace文件

Frank-Li

于 2013-03-18 21:25:17 发布

阅读量329

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL & PL/SQL 文章标签：根据request id找trace文件

本文链接：https://blog.youkuaiyun.com/lfl6848433/article/details/8689147

SQL & PL/SQL 专栏收录该内容

12 篇文章

订阅专栏

本文提供了一个复杂的Oracle SQL查询示例，用于从多个表中获取并发请求的跟踪文件名称及执行文件名等信息。通过联接fnd_concurrent_requests、v$sessions等表，实现了对特定请求ID相关信息的精确查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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