[ORACLE EBS]6. About Concurrent Manager

Concurrent Managers 是ORACLE ERP用来控制用户请求的管理器,通过他可以做定时处理,产生report和批处理。
Concurrent Manager有很多种,比如:
Internal Manager
Standard Manager
Receiving Transaction Manager
Receivables Tax Manager
SFM Controller Service
Inventory Manager
负责不同种类的REQUESTS, 最基本的有以下3个:
  • Internal Concurrent Manager (ICM) -  The Internal concurrent manager or the ICM is the 'master' concurrent manager. 主要用来管理其他的MANAGER,所以这个必须先起来。
    • (os process sample) FNDLIBR FND CPMGR FNDCPMBR sysmgr=""  logfile=...  
    • Standard Concurrent Manager - This the core manger and the most hard working of the three. 这个是最通用的Manager,通常的JOB,PROCESS都是由它来控制。除非,REQUEST有指定特殊的其他MANAGER。
      • (os process sample) FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/94
    • Conflict Resolution Manager (CRM) - The conflict resolution manager of the CRM is responsible of handling any conflicts that might occur within the concurrent programmes. 主要是为了避免REQUESTS间的冲突,比如,有些批处理,不能同时跑,等等。
      • (os process sample) FNDCRM APPS/889F9884A29D997F7676

    查询Manager SQL:
    SELECT  user_concurrent_queue_name manager, node_name node,
           running_processes actual, max_processes target, cache_size buf,
           diagnostic_level, enabled_flag
      
    FROM  fnd_concurrent_queues_vl
    ------------------------------
    Standard Manager                               3             3             6    N     Y
    PO Document Approval Manager     3             3                    N     Y

    查询Manager Process SQL:
    SELECT   DISTINCT  concurrent_process_id cpid, pid opid, os_process_id osid,
                    q.user_concurrent_queue_name manager, p.node_name node,
                    TO_CHAR (p.process_start_date,
                             
    ' YY-MM-DD HH24:MI:SS '
                            ) started_at,
                    p.logfile_name, p.process_status_code
               
    FROM  fnd_concurrent_processes p,
                    fnd_concurrent_queues_vl 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         os_process_id,
                    concurrent_process_id,
                    q.user_concurrent_queue_name
    ---------------------------------------------------------------------
    251606    10 8560 Internal Manager                              TestServer     08-01-21 14:07:25 ../TESTT.mgr     A
    251607    31 9527 Conflict Resolution Manager         TestServer     08-01-21 14:07:29 ../c251607.mgr A
    251609    32 9528 Scheduler/Prereleaser Manager  TestServer     08-01-21 14:07:29 ../s251609.mgr A
    查询Process Status Code SQL:
    SELECT   *
      
    FROM  fnd_lookups
     
    WHERE  lookup_type  LIKE   ' CP_PROCESS_STATUS_CODE '
    -----------------------------------------------------------------
    CP_PROCESS_STATUS_CODE     A     Active
    CP_PROCESS_STATUS_CODE     C     Connecting
    CP_PROCESS_STATUS_CODE     D     Deactiviating
    CP_PROCESS_STATUS_CODE     K     Terminated
    CP_PROCESS_STATUS_CODE     M     Migrating
    CP_PROCESS_STATUS_CODE     P     Suspended
    CP_PROCESS_STATUS_CODE     R     Running
    CP_PROCESS_STATUS_CODE     S     Deactivated
    CP_PROCESS_STATUS_CODE     T     Terminating
    CP_PROCESS_STATUS_CODE     Z     Initializing


    关于Cache Size:
    如果concurrent requests很少区分优先级,而且都是小的requests,可以设置cache size至少等于两倍的Target processs.
    这会加快处理量,减少sleep时间。其实就是来自FND_CONCURRENT_REQUESTS的信息被cache了。
    简单来说,加大CACHE SIZE时,concurrent manager会预先知道还有几个requests需要处理,就会避免进入sleep status.这样就可以连续处理。当然需要在资源允许的条件下,也不是所有的都可以设置的。
    • 0
      点赞
    • 2
      收藏
      觉得还不错? 一键收藏
    • 0
      评论
    评论
    添加红包

    请填写红包祝福语或标题

    红包个数最小为10个

    红包金额最低5元

    当前余额3.43前往充值 >
    需支付:10.00
    成就一亿技术人!
    领取后你会自动成为博主和红包主的粉丝 规则
    hope_wisdom
    发出的红包
    实付
    使用余额支付
    点击重新获取
    扫码支付
    钱包余额 0

    抵扣说明:

    1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
    2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

    余额充值