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

Thread: Tuning

  1. #1
    Join Date
    Apr 2004
    Posts
    14

    Tuning

    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.

    Regards

    Pradipta

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    Restarting the database is not a solution.
    You need to tune the SGA size.
    Increase the LOG_BUFFER size.

    Cheers.
    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
    Location
    Leeds, UK
    Posts
    367
    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
    Posts
    50
    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
    Posts
    14
    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.

    Pradipta

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by pradiptam
    I don't have as any major performance problem.
    Pradipta
    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