并发程序trace

用以下SQL找到相应的trc文件:

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

   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;