This discussion is archived
9 Replies Latest reply: Apr 5, 2013 5:24 PM by marksmithusa RSS

DB restart improves performance

user12288492 Newbie
Currently Being Moderated
About every month, our 11g R2 DB users complain of poor performance. When we restart our DB , performance improves. why? Is there any permanent soln so that we dont have to resatrt our DB.

Thanx in advance.
  • 1. Re: DB restart improves performance
    sb92075 Guru
    Currently Being Moderated
    user12288492 wrote:
    About every month, our 11g R2 DB users complain of poor performance. When we restart our DB , performance improves. why? Is there any permanent soln so that we dont have to resatrt our DB.

    Thanx in advance.
    http://en.wikipedia.org/wiki/Post_hoc
  • 2. Re: DB restart improves performance
    Kh$n Journeyer
    Currently Being Moderated
    OS VERSION?
    DB VERSION?
  • 3. Re: DB restart improves performance
    Aman.... Oracle ACE
    Currently Being Moderated
    user12288492 wrote:
    About every month, our 11g R2 DB users complain of poor performance. When we restart our DB , performance improves. why? Is there any permanent soln so that we dont have to resatrt our DB.

    Thanx in advance.
    What is "soln" or you wanted to say solution?

    When the users complain about poor performance, what you do to figure out the reason for such complaint? Who suggested to give a restart the db every month? What's the db version and o/s?

    Aman....
  • 4. Re: DB restart improves performance
    Maran Viswarayar Pro
    Currently Being Moderated
    Post your hardware/OS/DB relared info.

    It can be due to various reasons .

    OS resources are not released in time after a period - This can have impact on the overall performance
    Is your OS behaving normally when you have slowness- Something the server might just be too slow to respond.

    Need lot of inputs from you
  • 5. Re: DB restart improves performance
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    did you try to investigate before restart database , Asking Users , Generate AWR
  • 6. Re: DB restart improves performance
    jgarry Guru
    Currently Being Moderated
    If everything else fails, blame java. In addition to running statspack or awr during good and bad times to see what the db thinks the actual issue is (perhaps a shared pool issue?), try stopping the dbconsole.
  • 7. Re: DB restart improves performance
    Justin_Mungal Journeyer
    Currently Being Moderated
    user12288492 wrote:
    About every month, our 11g R2 DB users complain of poor performance. When we restart our DB , performance improves. why? Is there any permanent soln so that we dont have to resatrt our DB.

    Thanx in advance.
    This is unfortunate. Is that really the extent of your troubleshooting?

    Before you can truly solve a problem, you must understand it. Start from the top, and work your way down.

    -What's consuming the most resources on the server? Is it DB processes?
    -What is running in the DB that is consuming all of those resources?
    -Should that code be running? Is it using a sub-optimal execution plan?

    etc...

    You should educate yourself:
    http://docs.oracle.com/cd/E11882_01/server.112/e16638/toc.htm
  • 8. Re: DB restart improves performance
    Vikz28 Newbie
    Currently Being Moderated
    Hi,

    There are many things you need to consider prior restarting the database.

    First of all, you have to look at the inactive & stale sessions. Coordinating with database users & enquiring them about the events when the performance of database is degraded & it requires a restart. Then look for sessions that are in ACTIVE since long.

    And you have to start some tracing on the database using statspack or ADDM & identify the queries that are causing slowness or identify objects that are frequently used & try to rebuild those objects (if they are in large size).
  • 9. Re: DB restart improves performance
    marksmithusa Journeyer
    Currently Being Moderated
    jgarry wrote:
    If everything else fails, blame java.
    +1

    The beauty about blaming Java is that everyone knows Java is a steaming pile of .... and won't need to be convinced to believe it's the cause.

    The problem with blaming Java is that SOME people say 'well, Oracle owns it and you're a DBA!'

    !!!

    (I wish I was kidding, but I am not)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points