rem ----------------------------------------------------------------------- rem Filename: appinfo.sql rem Purpose: Script to display status of all the Concurrent Managers rem Author: Anonymous rem ----------------------------------------------------------------------- set head on column OsId format A10 justify left column CpId format 999999 column Opid format 999 column Manager format A30 column Status format A20 column Started_At format A30 column Cpid heading 'Concurrent|Process ID' column OsId heading 'System|Process ID' column Opid heading 'Oracle|Process ID' column Manager heading 'Concurrent Manager Name' column Status heading 'Status|of Concurrent|Manager' column Started_At heading 'Concurrent Manager|Started at' select distinct Concurrent_Process_Id CpId, PID Opid, Os_Process_ID Osid, Q.Concurrent_Queue_Name Manager, P.process_status_code Status, To_Char(P.Process_Start_Date, 'MM-DD-YYYY HH:MI:SSAM') Started_At from Fnd_Concurrent_Processes P, Fnd_Concurrent_Queues Q, FND_V$Process where Q.Application_Id = Queue_Application_ID and Q.Concurrent_Queue_ID = P.Concurrent_Queue_ID and Spid = Os_Process_ID and Process_Status_Code not in ('K','S') order by Concurrent_Process_ID, Os_Process_Id, Q.Concurrent_Queue_Name /