EBS OPP出错解决办法

最新推荐文章于 2022-03-30 09:51:36 发布

最新推荐文章于 2022-03-30 09:51:36 发布 · 905 阅读

文章标签：

#数据库 #runtime

本文介绍如何通过调整Oracle应用中的OPP（Oracle Process Pool）进程的堆内存大小来优化性能。具体步骤包括确定当前堆内存大小、更新配置参数、重启服务及清理并发管理表等。

具体：参考1268217.1

1. DEVELOPER_PARAMETERS of OPP is a runtime param of concurrent manager OPP, and the option of concurrent program 'XDOTMGEN' is a runtime param of the concurrent program. They are different.

And to this issue, it should tune DEVELOPER_PARAMETERS of OPP.

1. Determine what the heap size per OPP process is currently:
select DEVELOPER_PARAMETERS from FND_CP_SERVICES
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
2. The default should be:
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m
3. Increase the Heap Space per Process to 1024:
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');
4. Bring the managers down.
5. Run cmclean.sql script from Note 134007.1 - CMCLEAN.SQL Non-Destructive Script to Clean Concurrent Manager Tables.
6. Bring the managers up again.

2. XML Publisher Administration configuration navigation path :
XML Publisher Administrator > Home > Administration > Configuration.

Configure the XML Publisher Administrator Configuration settings.
1, As XML Publisher Administrator navigate to Administration->Configuration.
2. Under Temporary Directory pick a temporary file location on your concurrent processing node. This should be at least 5GB or 20x larger than largest XML data file you generate
3. Under FO Processing, set:
o Use XML Publisher's XSLT processor set to True
o Enable scalable feature of XSLT processor set to False
o Enable XSLT runtime optimization set to True