Best Practices for Oracle Database Performance

You should always verify that your Deployment Server machine meets the MTRs (refer to Accessing Certifications). The local Oracle database performs best on hard drives that are not fragmented or full. Additionally, the following table lists some guidelines for minimum configurations.

Specification	Recommendation
RAM	2 GB minimum
Page File Size	Minimum setting should be two times the amount of memory
Disk Space Usage	Oracle database engine requires approximately 1.7 GB of disk space JD Edwards EnterpriseOne specifications require approximately 1.7 GB of disk space When fully loaded, best performance is obtained if the hard drive on the Deployment Server machine has at least 20% free space.
Local Database Name	Ensure that any reference in data sources and .ini files refer to the local database name in the exact mixed case, which is: E1Local Failure to use the exact mixed case will lead to decreased performance of JD Edwards EnterpriseOne on the Deployment Server.