Performance Tuning of EBS 12.1.3

[soumya]

Hi Erman,

Hope you are doing well. I am a very frequent reader of your blog. Thanks for sharing all the information with us which makes our life really easy when it comes to EBS activities. I am a beginner into EBS technology. I have been digging the google to find out the right approach of how to tune a EBS Environment(Both DB and APPS) but  I have a few questions for you

1.what  approach should be taken if we face slowness in EBS Environment
2. How to effectively tune Concurrent manager? What factors to take care while tuning CM?
3. Could you please suggest any name of a book where i can have administrative knowledge of EBS environment. (p.s. I have the book "Practical Oracle E business suite" written by you.


I would be waiting for your reply.

Thanks . Keep up the good work!

[ErmanArslansOracleBlog]

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

[soumya]

Thanks a lot Erman. This will certainly help me . thanks