December 2002
Intermediate to advanced
928 pages
85h 29m
English
DB_BLOCK_BUFFERS
Value for Oracle8/8i: 4-operating system dependent
Default: 50 Value for Oracle9i: 50-operating system dependent
Default: 48M / DB_BLOCK_SIZE
Specifies the number of database buffers available in the buffer cache. This is one of the primary parameters that contribute to the total memory requirements of the SGA on the Oracle instance. The DB_BLOCK_BUFFERS parameter, together with the DB_BLOCK_SIZE parameter, determines the total size of the buffer cache.
With Oracle9i, Oracle recommends that you use DB_CACHE_SIZE instead of DB_BLOCK_BUFFERS.