DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Tuning

  1. #1
    Join Date
    Apr 2004


    Over a period of time the redo log space requests and redo buffer allocation retries parameter continuosly increase for my database. Once i restart the database it becomes zero and again the value increases.

    Is there any way to keep the value low?

    Mine is an online database with lots of inserts happening.



  2. #2
    Join Date
    Nov 2000
    Restarting the database is not a solution.
    You need to tune the SGA size.
    Increase the LOG_BUFFER size.

    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

  3. #3
    Join Date
    Feb 2003
    Leeds, UK
    Do you have a performance problem? Do you have evidence that those wait events are causing the performance problem? On the database I look after buffer busy waits are always in my top 5 wait events yet whenever I trace a performance issue I find that buffer busy waits contribute a tiny amount to the overall runtime duration of the session. I could try to eliminate those buffer busy waits, but the performance problem will still be there after I've finished. There's no point dealing with these if there are bigger fish to fry. Make sure you're dealing with the cause of a problem before worrying about it would be my advice.
    Last edited by hacketta1; 06-01-2004 at 07:07 AM.

  4. #4
    Join Date
    Feb 2004
    I agree with hacketta1

    "Do you have a performance problem? Do you have evidence that those wait events are causing the performance problem?"

    Unless you've done some benchmarks, rounding up the nearest suspects is not a good idea.

    And benchmarking your system at startup is meaningless.
    Until you've got the system cranked up to represent a typical database profile you are probably wasting your time. Until that shared pool and buffer cache are in full swing then it just isn't worth looking at any stats at all.

  5. #5
    Join Date
    Apr 2004
    I don't have as any major performance problem. Most of my tuning statistics are fine like Library cache hit ratio, Dictionary cache hit ratio and others. Only the redo log space requests is increasing with time.
    Meanwhile i am increasing my log buffer paramater and monitoring how the things are going on.


  6. #6
    Join Date
    Aug 2002
    Originally posted by pradiptam
    I don't have as any major performance problem.
    That's the spirit! If it ain't broke screw around with it until it's completely messed up!
    I'm stmontgo and I approve of this message

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.