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