IBM FileNet P8, Version 5.2.1            

Preventing Oracle connectivity issues

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.

Table 1. Oracle parameters that help to prevent connectivity issues
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).


Last updated: October 2015
p8ppt107.htm

© Copyright IBM Corporation 2015.