Oracle EBS R12 - 根据request_id查trace文件的SQL

t0nsha

于 2013-03-02 19:30:20 发布

阅读量2.4k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Oracle - EBS/APP

本文链接：https://blog.youkuaiyun.com/t0nsha/article/details/8629628

Oracle - EBS/APP 专栏收录该内容

75 篇文章

订阅专栏

本文详细解释了如何通过并发请求ID找到由该ID生成的跟踪文件，包括必要的SQL查询步骤。

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

VER:

Application: EBS R12.0.6

Database: Oracle 10gR2

SQL:

SELECT fcr.request_id
      ,fcr.enable_trace
      ,   vp1.VALUE
       || '/'
       || LOWER (vp2.VALUE)
       || '_ora_'
       || fcr.oracle_process_id
       || '.trc'
          trace_path
FROM   fnd_concurrent_requests fcr
      ,v$parameter vp1
      ,v$parameter vp2
WHERE      vp1.name = 'user_dump_dest'
       AND vp2.name = 'db_name'
       AND fcr.request_id = &request_id;

REF:

1. Given a concurrent request id how do you find the trace file generated by this request id
http://allappsdba.blogspot.com/2012/05/2-given-concurrent-request-id-how-do.html