DB_BLOCK_BUFFER & LOG_BUFFER too large
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DB_BLOCK_BUFFER & LOG_BUFFER too large

  1. #1
    Join Date
    Oct 2001
    Posts
    52
    Hi,
    Can some one advise me what will happen if DBA set the size of DB_BLOCK_BUFFER & LOG_BUFFER too large in the init.ora file? Will it degrade the database performance?
    Thank you for your advise.
    Rdgs,
    Chuah

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    You may set DB_BLOCK_BUFFER as high as you wish as long as you do not reach the point of paging or swapping. Then performance will really suffer!

    If LOG_BUFFER is very large then the background writes will be seldom triggered. Accordingly, redo will have to be flushed by sync writes. So you will have lots of "log file sync waits" which directly affects the commit respond time.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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