Private Read-only Buffers (-Bp)

Use Private Read-only Buffers (-Bp) to request a number of private read-only buffers.

Operating system and syntax UNIX / Windows -Bp n
Use with Maximum value Minimum value Single-user default Multi-user default
Client Connection 64 1 — —
n
An integer value greater than 1 but less than 64.

The request remains active for the entire session unless it is changed or disabled by an application. Each user of private read-only buffers reduces the number of public buffers, which is set with Blocks in Database Buffers (-B). The total number of private read-only buffers for all simultaneous users is limited to 25% of the total blocks in database buffers.