This discussion is archived
5 Replies Latest reply: Jun 11, 2012 10:54 PM by Helios-GunesEROL RSS

my data base very slow

user11876003 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.... Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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

Legend

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