本文共 611 字,大约阅读时间需要 2 分钟。
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_pathFROM fnd_concurrent_requests fcr ,v$parameter vp1 ,v$parameter vp2WHERE 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转载地址:http://kitai.baihongyu.com/