Re: High CPU usage

From: shiva <sshivayogi_at_gmail.com>
Date: 11 Oct 2006 21:38:40 -0700
Message-ID: <1160627920.779782.123280@k70g2000cwa.googlegroups.com>

Valentin Minzatu wrote:
> I agree these are basic questions, but:
> i) have you analyzed the database (system + application tables)?
Just application user stats. No system stats yet.

> ii) have you run a AWR report? where is the database time spent: I/O, CPU, interconnect?
I went through the AWR report. I/O is non issue. Interconnect is also not an issue, there is not one process which is consuming significant CPU. There are quite a few connections and each of them is taking about 0.25% of CPU . ps -eaf|grep oracle|wc -l shows 156 processes are running on it at this moment. (Including background)

> Cheers,
> Valentin
Received on Wed Oct 11 2006 - 23:38:40 CDT