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 |