MyOracleWorld.Net  .........

 

Concurrent Manager Status - When Last The Concurrent Managers was Started

The below script shows allt he concurrent managers - when they were started, and the status of each of them

set linesize 140;  

Column OsId       Format A10  

Column CpId       Format 999999  

Column Opid       Format 999  

Column Manager    Format A30  

Column Status     Format A20  

Column Started_At Format A30 

Column NodeName   Format A15

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'  

Column Opid       Justify  Left  

 

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 , 

p.node_name NodeName 

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  Process_Status_Code not in ('K','S')  

Order by Concurrent_Process_ID, Os_Process_Id, Q.Concurrent_Queue_Name; 

 

SQL> l
  1  Select distinct Concurrent_Process_Id CpId, PID Opid,
  2  Os_Process_ID Osid,
  3  Q.Concurrent_Queue_Name Manager,
  4  P.process_status_code Status,
  5  To_Char(P.Process_Start_Date, 'MM-DD-YYYY HH:MI:SSAM') Started_At ,
  6  p.node_name NodeName
  7  from  Fnd_Concurrent_Processes P, Fnd_Concurrent_Queues Q, FND_V$Process
  8  where  Q.Application_Id = Queue_Application_ID
  9  And (Q.Concurrent_Queue_ID = P.Concurrent_Queue_ID)
 10  And  Process_Status_Code not in ('K','S')
 11* Order by Concurrent_Process_ID, Os_Process_Id, Q.Concurrent_Queue_Name
SQL> /

                                                Status
Concurrent Oracle     System     Concurrent    of Concurrent Concurrent Manager
Process ID Process ID Process ID Manager Name  Manager       Started at            Nodename

---------- ---------- ---------- ------------- ------------- --------------------- ----------- 

      6760          2 11783      FNDICM                    A 05-04-2011 05:08:13PM ORACLERH6PW7
      6760          3 11783      FNDICM                    A 05-04-2011 05:08:13PM ORACLERH6PW7
      6760          4 11783      FNDICM                    A 05-04-2011 05:08:13PM ORACLERH6PW7
      6760          5 11783      FNDICM                    A 05-04-2011 05:08:13PM ORACLERH6PW7
      6760          6 11783      FNDICM                    A 05-04-2011 05:08:13PM ORACLERH6PW7
      6760          7 11783      FNDICM                    A 05-04-2011 05:08:13PM ORACLERH6PW7
      6760          8 11783      FNDICM                    A 05-04-2011 05:08:13PM ORACLERH6PW7
      6760          9 11783      FNDICM                    A 05-04-2011 05:08:13PM ORACLERH6PW7
      6760         10 11783      FNDICM                    A 05-04-2011 05:08:13PM ORACLERH6PW7

      6760         11 11783      FNDICM                    A 05-04-2011 05:08:13PM ORACLERH6PW7
      
6762          2 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762          3 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762          4 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762          5 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762          6 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762          7 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7

      6762          8 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762          9 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         10 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         11 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         12 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         13 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         14 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         15 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         16 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7

      6762         17 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         18 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         19 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         20 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         21 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6762         22 12203      FNDSM_ORACLERH6PW7        A 05-04-2011 05:08:14PM ORACLERH6PW7
      6765          2 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765          3 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765          4 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7

      6765          5 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765          6 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765          7 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765          8 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765          9 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         10 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         11 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         12 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         13 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7

      6765         14 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         15 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         16 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         17 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         18 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         19 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         20 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         21 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7
      6765         22 12270      FNDCPOPP                  A 05-04-2011 05:08:15PM ORACLERH6PW7

      6775          2 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775          3 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775          4 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775          5 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775          6 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775          7 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775          8 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775          9 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         10 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7

      6775         11 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         12 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         13 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         14 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         15 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         16 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         17 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         18 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         19 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7

      6775         20 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         21 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7
      6775         22 12312      PASMGR                    A 05-04-2011 05:08:17PM ORACLERH6PW7

 

84 rows selected.

SQL>

Rules for commenting:

  • Only comment to articles on this page - each page have it's own comment box.
  • Comments/questions irrelevant to the content of this page will be removed.
  • Non-valid email adresses will be treated as SPAM and will be deleted by htmlcommentbox, without me even knowing about it. I have no control over what adresses gets detected by htmlcommentbox as invalid. 

 

 
HTML Comment Box is loading comments...