Re: oracle - high cpu usage
- From: hpuxrac <johnbhurley@xxxxxxxxxxxxx>
- Date: Wed, 30 Jul 2008 07:33:23 -0700 (PDT)
On Jul 30, 10:16 am, kawu <k...@xxxxxxx> 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.
.
- Follow-Ups:
- Re: oracle - high cpu usage
- From: kw
- Re: oracle - high cpu usage
- From: rgdavi
- Re: oracle - high cpu usage
- References:
- oracle - high cpu usage
- From: kawu
- oracle - high cpu usage
- Prev by Date: oracle - high cpu usage
- Next by Date: Re: Moving/compressing *.trc files.
- Previous by thread: oracle - high cpu usage
- Next by thread: Re: oracle - high cpu usage
- Index(es):
Relevant Pages
|
