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.