Optimize 10.11 | webMethods Optimize Documentation | Administering webMethods Optimize | For Database Administrators | Installing Optimize Database Component Sets | Database Component Sets
 
Database Component Sets
Optimize requires four sets of database components:
*Analysis
*Process Tracker
*Process Audit Log
*My webMethods Server
All four Optimize database component sets can reside in the same schema on the same database. However, you can improve performance by distributing the database load over multiple database servers. To do so, you install the Optimize database component sets on different database servers and then configure the JDBC pools to point to the appropriate schemas on those database servers.
Note:
If you are using an Oracle database for the Analysis component of an Optimize installation, set the Oracle open_cursors value to 2000 to minimize the chance of running out of cursors and generating an open cursors error. This setting may be especially critical for systems that are running under a heavy load.