redo buffer allocation retries
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: redo buffer allocation retries

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    Hi friends,
    we are running OPS in 8.1.6.0.0 on a Compaq Tru64 5.0A.
    The redo log buffers are sized at 163840.
    The 'redo buffer allocation retries' seem to be on a high side. The query
    SQL> select inst_id,value from gv$sysstat where name='redo buffer allocation retries';

    returns the following:

    INST_ID VALUE
    ---------- ----------
    2 2710
    1 6911

    Is it necessacry, that the log_buffers should be increased from the present value?
    How does retaining the same will affect the performance?

    Thanks
    manjunath

  2. #2
    Join Date
    Jun 2001
    Posts
    87

    Redo etc



    Oracle reccommends that retries should be less than 1% of redo entries. If is not then it should be OK to increase the log_ buffer. If it is then increasing the log_buffer will not result in any noticeable benefits. I think you need to collect a bit more statistics.

    Good Luck

  3. #3
    Join Date
    Oct 2000
    Posts
    211
    Thanks.
    How can I know the redo entries?
    And can you provide links to the doc. where it says it should be 1% of the entries? Because, I could only get "The value of REDO BUFFER ALLOCATION RETRIES should be near zero. "
    Thanks again
    manjunath

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