increasing ram to counter slow query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: increasing ram to counter slow query

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    increasing ram to counter slow query

    Hi

    Recently, the users experience slowness in running oracle queries. Without hesitation, my management decided to go ahead with getting more ram.

    1) With more ram, will the slowness go away?

    2) even with more ram, one still need to configure , ie, the shared pool, data buffer,redo buffer in order to take advantage of this increase in memory?

    3) anyway, i think the crux is not the hardware but rather the examiniation of the slowness. Without the latter, my management went straight away to getting more ram. A more realistic method will be getting more CPUs instead.

    Please advise.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why is more CPU's realistic? It's as stupid an idea as more memory is.

    You may be i/o bound. How about finding the cause of the problem and fixing it, which is surely where you come in?

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If I remember correctly, Cary Millsap gives an example in his book where upgrading hardware made things run slower!

    Do as davey23uk says - find the cause of the problem.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  4. #4
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    You could maybe try analyzing your database on a regular basis too. This has had a dramatic effect on a couple of our applications. There may be other tools available to investigate at the OS level, but what OS is it?
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    pick up few slow running queries and i am sure u will see bad plans for those..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I agree to a facts-driven, knowledge-based systematic approach to tuning.

    Throwing hardware or regularly computing statistics "at a problem" will fix the problem some times, but knowing where your bottleneck is will save your career.

    Buy a book on tuning your specific version. Read it and apply it.

    -Ken

    PS. Sometimes adding memory and caching a table is the right approach.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: increasing ram to counter slow query

    Originally posted by yls177
    Hi

    Recently, the users experience slowness in running oracle queries. Without hesitation, my management decided to go ahead with getting more ram.

    1) With more ram, will the slowness go away?

    and if it does, what does that mean the next time?


    2) even with more ram, one still need to configure , ie, the shared pool, data buffer,redo buffer in order to take advantage of this increase in memory?

    Unless you have paging/swapping problems.


    3) anyway, i think the crux is not the hardware but rather the examiniation of the slowness. Without the latter, my management went straight away to getting more ram. A more realistic method will be getting more CPUs instead.
    How so? If you don't know what the problem is how can you suggest more hardware?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I can't believe that I'm the first to say "statspack"! world's smnallest hooray for me.

    But anyway, get statspack running for a fifteen minute interval when the database appears to be under pressure, then pull the top SQL's from it. You could easily have a handful of badly tuned SQL in there that is the source of 90% of your problems.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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