To configure the value of open_cursors in the eXchange Integrator database

1. Start the Oracle configuration utility and open the eXchange database.

2. Navigate to Databases⇒;(EXCHANGE...)⇒Instance⇒Configuration.

3. In the General tab, at the bottom, verify the “Started with spfile” parameter has a value such as %ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA.

   Figure 2–8 Oracle Configuration of Initialization Parameters: General Tab

   
   

4. In the “Edit Database: Configuration [...]” dialog box, click the SPFile option button, scroll to the open_cursors parameter, and change its value to 500.

   

5. Click the Apply button. In response to the prompt (“Would you like to apply this change to the current database?”), click Yes.