DB_BLOCK_BUFFERS & DB_CACHE_SIZE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DB_BLOCK_BUFFERS & DB_CACHE_SIZE

Hybrid View

  1. #1
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145
    !hi

    In Oracle 9i what the difference between

    DB_BLOCK_BUFFERS AND DB_CACHE_SIZE.

    how these parameter's will work?

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi,

    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

    Angel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width