Re: Performance Tuning of EBS 12.1.3

Posted by ErmanArslansOracleBlog on Jun 24, 2020; 10:55am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Performance-Tuning-of-EBS-12-1-3-tp8461p8462.html

Thank you Soumya!
It makes me happy to receive such feedbacks :)

1) You should analyze the performance problem, find the cause and implement the solution accordingly.
You should analyze the environment by considering the EBS 3-tier architecture, the big picture in the first place.. You should start from the frontend and drill down to the backend (the database, APPS Schema and OS layers)
You should be able to check OS resource and performance as well..
You should be able to check the Apps server's performance, the oc4j instances, forms & reports server, concurrent processing environment , the database itself, the customizations and so on..

2) The tunables in Current processing environment are already certain.

Concurrent manager cache, process counts and sleep times are some of the important tunables in this area.

https://ermanarslan.blogspot.com/2016/04/ebs-r12-concurrent-manager-facts-cache.html

You should also check the code, the concurrent programs itself, their database side codes too.
Also, the corrective action may be a general one , but it can also depend on a problematic concurrent manager..  You should analyze and identify the concurrent manager, or code that causing the problem first..
For instance , if it is related with OPP , then you will implement an OPP-aware corrective action..
You get the idea right?

In general, CP analyzer may give you some clues for the performance and health of your concurrent processing environment->

https://ermanarslan.blogspot.com/2014/12/ebs-analyzing-concurrent-processing-cp.html

3) You should definetely read my book. We have a chapter dedicated to EBS performance ->

Chapter 13 : Oracle E-Business Suite 12.2 Performance Recommendations

Performance recommendations for EBS 12.1.3 are almost the same..

For concurrent processing environment, please read ->

Chapter 10 - Oracle EBS Concurrent Manager

Practical Oracle E-businesss Suite + the documents in Oracle Support (support.oracle.com) website should be  enough for you to solve these problems.

https://www.amazon.com/Practical-Oracle-Business-Suite-Implementation/dp/1484214234

Extra: Please read the following too ->

EBS -- Health Check , Preparing a comprehensive Health check report
https://ermanarslan.blogspot.com/2015/03/ebs-health-check-preparing.html