DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2001
    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.

  2. #2
    Join Date
    Jun 2001
    Helsinki. Finland
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.