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

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