5 Replies Latest reply: Jun 12, 2012 12:54 AM by Helios-GunesEROL RSS

    my data base very slow

    user11876003
      Dear all,

      I have oracle rac db time to time its going very slow i can't recognize why this is happen how to check this . When the db load is going high then application also restarted .


      An that time load average going very high ,only one node
        • 1. Re: my data base very slow
          sb92075
          user11876003 wrote:
          Dear all,

          I have oracle rac db time to time its going very slow i can't recognize why this is happen how to check this . When the db load is going high then application also restarted .


          An that time load average going very high ,only one node
          what SQL is slow?
          enable SQL_TRACE for the slow SQL
          • 2. Re: my data base very slow
            CKPT
            user11876003 wrote:
            Dear all,

            I have oracle rac db time to time its going very slow i can't recognize why this is happen how to check this . When the db load is going high then application also restarted .


            An that time load average going very high ,only one node
            What is the version?
            You mean to say whole database slowness? Run AWR report for 1 hour duration, see whats going on.
            Also work on load balancing, Check the services configured properly.
            • 3. Re: my data base very slow
              Aman....
              user11876003 wrote:
              Dear all,

              I have oracle rac db time to time its going very slow i can't recognize why this is happen how to check this . When the db load is going high then application also restarted .


              An that time load average going very high ,only one node
              Its actually nothing that you have told us to suggest something. What's the db version and o/s? Oracle database won't restart any application if being slow. That you should take up with the application development team of yours. For the database, depending on your db version and license, get either a Statspack or AWR of not longer than 30 minutes and post here .

              Aman....
              • 4. Re: my data base very slow
                user11876003
                oracle 11g
                Linux version 2.6.18-92.el5 (brewbuilder@ls20-bc2-13.build.redhat.com) (gcc version 4.1.2 20071124 (Red Hat 4.1.2-41)) #1 SMP Tue Apr 29 13:16:15 EDT 2008

                this is the version
                • 5. Re: my data base very slow
                  Helios-GunesEROL
                  Hi;

                  Your sharing and your question is not clear.

                  1. What is exact db version
                  2. Is there new query add on db or it always work slow
                  3. Did you check your AWR and ASH?
                  4. Oswatcher enable? Did you check which or what eating your source?
                  5. Is there any error message in alert.log?

                  Regard
                  Helios