sizing database buffer cache
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: sizing database buffer cache

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Gurus

    I want to set my buffer cache size to about 100M, or 150M or 200M. My block size is 8192bytes, how do I calculate my db_block_buffers parameter??? Please provide details.

    Thanks in advance!
    roukie-dba

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    eh??? what do you mean how to calculate?

  3. #3
    Join Date
    Jan 2002
    Posts
    148
    db_buffer_cache_size / db_block_size = round(db_block_buffers)

    Jr.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    sorry I thoguht it was more advanced question... :(

  5. #5
    Join Date
    Nov 1999
    Location
    Kuwait
    Posts
    122

    db_buffer_cache_size?

    JR,

    I might be wrong but do this db_buffer_cache_size known as any other thing in ORACLE 8???
    NK
    ====================================================
    Stand up for your principles even if you stand alone!
    ====================================================

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