9 Replies Latest reply: Apr 5, 2013 7:24 PM by marksmithusa RSS

    DB restart improves performance

    user12288492
      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
          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
            OS VERSION?
            DB VERSION?
            • 3. Re: DB restart improves performance
              Aman....
              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
                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
                  did you try to investigate before restart database , Asking Users , Generate AWR
                  • 6. Re: DB restart improves performance
                    jgarry
                    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
                      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
                        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
                          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)