1. Server Manager Guide
  2. Improve Workload Performance for an Oracle Database (9.2.7)

Improve Workload Performance for an Oracle Database (9.2.7)

Increasing the fetch size for JD Edwards EnterpriseOne components to an optimal value may improve the performance of queries from the JD Edwards database driver to an Oracle database.

By default JD Edwards EnterpriseOne fetches a preset number of rows and bytes from an Oracle database. However, you can override the default setting by using Server Manager to:

  • Configure the Database Fetch Size on the Enterprise Server
  • Set the SQL Statement Fetch Size on the HTML Server