Recommended maintenance tasks

[msantaana]

Hi Erman, we are about to enter production in a few months and we would like to know the performance improvements that can be made according to your experience. Such as purge tables, preventive maintenance, archive methods, obsolete File System files, etc.

Thanks in Advanced.

[ErmanArslansOracleBlog]

Hi Msantaana,

you can read my book. It is focused on EBS 12.2. We have a seperate chapter named : "Chapter 13 - Oracle E-Business Suite 12.2 Performance Recommendations"

Here is the link:

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

Lots of things to do there...

The ares for the performance recommedations:

EBS 12.2 Client-Side Performance Tuning
EBS 12.2 Middle Tier Performance Tuning
EBS 12.2 Database Structure and Performance
Inıtialization Parameters
Tablespaces, Data Files, and Redolog Files
EBS 12.2 SQL Access Paths
EBS 12.2 Network Performance Tuning
EBS 12.2 Tuning the Concurrent Processing
Performance Recommendations for Reporting, Workflow, and Application Debug Profiles

[msantaana]

Excellent Erman, I'll read you book.
Thanks