正德厚生,臻于至善

EBS OPP调优

参考文档:Publisher 并发程序由于”输出提交处理程序提交失败

• Document 1399454.1,Tuning Output Post Processor (OPP) to Improve Performance

• Document 2028617.1,Output Post Processor (OPP) Hangs With High CPU Utilization

NOTE:291792.1 – Concurrent Processing – Using the Concurrent Request Output Post Processor (OPP) in Oracle Applications

NOTE:1982181.1 – How to Resolve Output Post Processor Giving Errors On Large Reports?
NOTE:352518.1 – Concurrent Requests Fail Due To Output Post Processing (OPP) Timeout
NOTE:858813.1 – Concurrent Processing – Output Post Processor is Down with Actual Process is 0 And Target Process is 1

 

1. How to monitor the workload of OPP

当OPP开始处理并发请求时,它将使用concurrent_process_id更新fnd_conc_pp_actions的processor_id列。 我们可以使用以下查询来查找针对OPP的待处理请求:

       SQL> select concurrent_request_id, action_type
from fnd_conc_pp_actions
where action_type >= 6
and processor_id is null;

2. Tuning OPP to Improve Performance.

2.1  OPP Definition

2.2  Process Vs Thread

3. Tuning Heap Size to avoid OutOfMemoryError

SELECT service_id, service_handle, developer_parameters
FROM fnd_cp_services
WHERE service_id = (SELECT manager_type
FROM fnd_concurrent_queues
WHERE concurrent_queue_name = ‘FNDCPOPP’);

3.1 Increase Java heap size for the OPP to higher value. The maximum is 2048MB (2GB)

UPDATE fnd_cp_services
SET developer_parameters =
‘J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m’
WHERE service_id = (SELECT manager_type
FROM fnd_concurrent_queues
WHERE concurrent_queue_name = ‘FNDCPOPP’);

This example, Heap size is updated as 2GB and along with minimum Heap Size as 2GB(ms2048M).

 

UPDATE fnd_cp_services
SET developer_parameters =
‘J:oracle.apps.fnd.cp.gsf.GSMServiceController:-Xmx2048M -Xms2048M’
WHERE service_id = (SELECT manager_type
FROM fnd_concurrent_queues
WHERE concurrent_queue_name = ‘FNDCPOPP’);

 

Note This update will override the default -Xmx384m setting for the JVM as defined by AFJSMARG environment variable in the Apps environment file.

$ echo $AFJSMARG
-server -Xmx384m -XX:NewRatio=2 -XX:+UseSerialGC -Doracle.apps.fnd.common.Pool.leak.mode=stderr:off -verbose:gc

4.  OPP Hangs With High CPU Utilization 

赞(0) 打赏
未经允许不得转载:徐万新之路 » EBS OPP调优
分享到: 更多 (0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏