In Oracle 9i what the difference between
DB_BLOCK_BUFFERS AND DB_CACHE_SIZE.
how these parameter's will work?
Same. DB_CACHE_SIZE is the new name, DB_BLOCK_BUFFERS is being kept for BC. If you use DB_BLOCK_BUFFERS, the value will be set but you'll get a warning message. It will be made obsolete in Oracle 10.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
The Oracle9i Buffer cache can be divided 7 ways: 2K blocks, 4K blocks, 8K blocks, 16K blocks, 32K blocks, Keep, and Recycle. Keep and Recycle can only be specified for the database block size, DB_BLOCK_SIZE.
DB_CACHE_SIZE -> size of Default buffer pool
DB_KEEP_CACHE_SIZE -> size of Keep buffer pool
DB_RECYCLE_CACHE_SIZE -> size of Recycle buffer pool
DB_nK_CACHE_SIZE -> cache size for non-default block size(s)
The DB_CACHE_SIZE parameter specifies the size of the cache for the default block size (DB_BLOCK_SIZE).
Other caches are specified using the DB_nK_CACHE_SIZE parameters. For example DB_2K_CACHE, DB_4K_CACHE_SIZE, etc.
2K, 4K, 8K, 16K and 32K can be specified.
Since DB_CACHE_SIZE specifies the cache for the default block size you cannot explicitly specify a cache for that. For example if your default block size is 8K then you cannot specify DB_8K_CACHE_SIZE.
Oracle matches up the block size of the tablespace an object is stored in with the appropriate cache.
Note: DB_BLOCK_BUFFERS, BUFFER_POOL_KEEP, and BUFFER_POOL_RECYCLE have been deprecated in Oracle9i (recommend using the newer CACHE_SIZE parameters).
Hope this will help you
Click Here to Expand Forum to Full Width