Increasing the values of the Oracle parameters in the following table can prevent database connectivity issues when an IBM® FileNet® P8 application requires many simultaneous connections to an Oracle database.
The values of these parameters enable the Oracle database instance to sustain the total number of possible simultaneous connections for all object stores in the database instance.
Parameter name | Description |
---|---|
db_file_multiblock_read_count | Minimizes disk I/O during table scans by specifying the maximum number of blocks read in one I/O operation during a sequential scan. |
processes | Specifies the maximum number of operating system user processes that can simultaneously connect to an Oracle server. This value accommodates all background processes such as Job Queue (SNP) and parallel execution (Pnnn) processes. |
sessions | Specifies the
total number of user and system
sessions. Note:
The default number is greater than PROCESSES
to allow for recursive sessions. The sessions default is derived (1.1
* PROCESSES + 5). |