Wednesday, July 11, 2012

Concurrent processes information script

The following query will display useful information about your eBS' concurrent processes:
  SELECT P.CONCURRENT_PROCESS_ID,
         QU.USER_CONCURRENT_QUEUE_NAME,
         QU.CONCURRENT_QUEUE_NAME,
         DECODE (P.PROCESS_STATUS_CODE,
                 'A', 'Active',
                 'G', 'Awaiting Discovery',
                 'C', 'Connecting',
                 'S', 'Deactivated',
                 'D', 'Deactiviating',
                 'Z', 'Initializing',
                 'M', 'Migrating',
                 'R', 'Running',
                 'P', 'Suspended',
                 'K', 'Terminated',
                 'T', 'Terminating',
                 'Unknown')
            "STATUS",
         P.NODE_NAME,
         P.OS_PROCESS_ID,
         P.DB_NAME,
         P.DB_INSTANCE,
         SS.SID,
         P.ORACLE_PROCESS_ID,
         P.PROCESS_START_DATE,
         P.MANAGER_TYPE,
         P.LOGFILE_NAME
    FROM APPLSYS.FND_CONCURRENT_PROCESSES P,
         APPS.FND_CONCURRENT_QUEUES_VL QU,
         GV$SESSION SS
   WHERE     P.CONCURRENT_QUEUE_ID = QU.CONCURRENT_QUEUE_ID
         AND P.SESSION_ID = SS.AUDSID(+)
         AND P.INSTANCE_NUMBER = SS.INST_ID(+)

No comments:

Post a Comment