Blocks in Database Buffers (-B)

Operating system and syntax UNIX / Windows
-B n
Use with Maximum value1 Minimum value Single-user default Multi-user default2
CC, DBS 1,000,000,000 or 125,000,000 10 20 Maximum of (8 * users) or 3000
n
The number of blocks in the database buffers.

Use Blocks in Database Buffers (-B) to specify the number of blocks in the database buffers. The optimum value depends on your application. Validations to ensure database consistency in both index and data blocks during forward processing.using -B can be run online as part of routine health checks. For more information, see PROUTIL Utility .

To modify this parameter while the database is online, use PROUTIL INCREASETO.

You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.

1 The maximum value of the sum of -B + -B2: 1,000,000,000 for 64-bit platforms; 125,000,000 for 32-bit platforms. The maximum is system dependent and limited by available memory.
2 The users value is specified by the Number of Users (-n) parameter.