Re: oracle - high cpu usage
From: kw <kw_at_spam.pl>
Date: Wed, 30 Jul 2008 19:16:28 +0200
Message-ID: <g6q7o5$ihe$1@atlantis.news.neostrada.pl>
>
> 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.
>
Date: Wed, 30 Jul 2008 19:16:28 +0200
Message-ID: <g6q7o5$ihe$1@atlantis.news.neostrada.pl>
hpuxrac pisze:
> 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.
>
It's Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production on SunOS 5.9 sparc.
I could login to database as sysdba. Received on Wed Jul 30 2008 - 12:16:28 CDT