Re: oracle - high cpu usage

From: kw <>
Date: Wed, 30 Jul 2008 19:16:28 +0200
Message-ID: <g6q7o5$ihe$>

hpuxrac pisze:
> On Jul 30, 10:16 am, kawu <> 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.

It's Oracle9i Enterprise Edition Release - 64bit Production on SunOS 5.9 sparc.

I could login to database as sysdba. Received on Wed Jul 30 2008 - 12:16:28 CDT

Original text of this message