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. |