Progress
Database Administration
Guide and Reference


Size Of Database Buffer Pool

The size of the database buffer pool is set by the -B (Blocks in Database Buffers) startup parameter. The maximum is 500,000 blocks. Table 3–7 lists the maximum size of the buffer pool.

Table 3–7: Maximum Buffer Pool Size 
Block Size
Maximum Buffer Pool Size
1024 bytes (1K)
500 MB
2048 bytes (2K)
1 GB
4096 bytes (4K)
2 GB
8192 bytes (8K)
4 GB

Progress allows you to specify some number of buffers in the buffer pool as private read-only buffers. The -Bp (Private Read-Only Buffers) startup parameter allows you to specify what number of buffers you wish to be private read-only buffers. The default number of private read-only buffers that a single user can request is 64 and the maximum number is limited by the -bpmax parameter. The maximum number of private read-only buffers for all simultaneous Progress users is limited to 25% of the database buffer pool.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095