Parameter Configuration

open_cursors

If the value of open_cursors is too low, the following message may be displayed when the system is under load:

ORA-01000: maximum open cursors exceeded

The default value is 50. To see the current value, enter the following Oracle command:

SHOW PARAMETERS cursors;

On an ActiveMatrix BPM system, TIBCO recommends setting this value to a minimum of 400. To change the current value, enter the following command (specific to your Oracle installation):

ALTER SYSTEM SET open_cursors=400 scope=spfile;

If the error message is displayed again, consider increasing the value.

processes

The parameter processes specifies the maximum number of operating system user processes that can simultaneously connect to Oracle.

The default value is 100. To see the current value, enter the following Oracle command:

SHOW PARAMETERS processes;

To determine whether you should increase the current value, you can add together all background processes (such as locks, job queue processes, and parallel execution processes) and the Maximum Connections values for each JDBC resource that will use the database. To change the current value, enter the following command (specific to your Oracle installation):

ALTER SYSTEM SET processes=1500 scope=spfile;