Re: oracle - high cpu usage
Date: Wed, 30 Jul 2008 07:33:23 -0700 (PDT)
Message-ID: <d1d786e8-4246-437d-a02c-765749bd988f@25g2000hsx.googlegroups.com>
On Jul 30, 10:16 am, kawu <k..._at_spam.pl> wrote:
> Hi,
>
> Few days ago my database "eat" a lots of CPU and has high events waits
> and I/O waits. Now problem is gone, but I want to know what to do in
> future if that situation come back. How to find which session/sql cause
> problem? What to do with that session?
>
> Thanks in advance,
> kawu.
What version and what platform are you running oracle on? Enterprise edition, standard, or what?
What monitoring tools does your organization have setup if any?
Do you have any kind of direct access into the database and what kind of role do you have?
If your database is relatively recent OEM provides a fairly nice way to see what's impacting your database. Using it well depends on your experience level with oracle as a database and your experience as a developer/tuner. Received on Wed Jul 30 2008 - 09:33:23 CDT