Re: CPU is 0% idle- Performance issue in 10g database

From: AMIT VERMA <verma.labs_at_gmail.com>
Date: Thu, 17 Apr 2008 01:09:58 +0530
Message-ID: <9ef8914e0804161239j3dbb3e82q6eeaa6ec76fc5710@mail.gmail.com>


Please provide the output of the following:-

sar |grep 'Average:' | awk '{print $3 "\t" $4 "\t" $5 "\t" $6 "\t" $7}'

On Thu, Apr 17, 2008 at 12:42 AM, Shastry(DBA) <shastry17_at_gmail.com> wrote:

> Hi Gurus,
>
> We did upgrade to 10.2.0.3 from 9i and there is a performance degrade. The
> CPU looks like below
>
> last pid: 4118; load averages: 56.40, 59.29,
> 58.40
> 12:05:15
> 270 processes: 207 sleeping, 59 running, 1 zombie, 3 on cpu
> CPU states: 0.0% idle, 89.0% user, 11.0% kernel, 0.0% iowait, 0.0% swap
> Memory: 16G real, 6573M free, 6571M swap in use, 38G swap free
>
> All the processes are oracle on the top which are running. Any light on
> this how we can proceed in tuning/ working around on this as am not much
> exposed to PT.
>
> Thanks,
> Ann
>
>

-- 
Amit Verma
Oracle DBA & Unix Admin.


"Winning takes talent but it takes character to keep winning"

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 16 2008 - 14:39:58 CDT

Original text of this message