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

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