oracle - high cpu usage

From: kawu <kw_at_spam.pl>
Date: Wed, 30 Jul 2008 16:16:06 +0200
Message-ID: <g6pt37$f27$1@news.onet.pl>


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. Received on Wed Jul 30 2008 - 09:16:06 CDT

Original text of this message