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

I am getting the below error for the previous command.

-bash-3.00$ sar |grep 'Average:' | awk '{print $3 "\t" $4 "\t" $5 "\t" $6 "\t" $7}'
sar: can't open /var/adm/sa/sa16
No such file or directory

Please help !

Thanks,
Ann

On Thu, Apr 17, 2008 at 1:09 AM, AMIT VERMA <verma.labs_at_gmail.com> wrote:

> 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