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

9i to 10g upgrade has some performance changes, enough to cause 100% cpu.

Do not have link handy for upgrade Gotcha's.  

Thanks,

PB Singh  

PB Singh

DW Architect and Sr Data Modeler

VMware  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shastry(DBA)
Sent: Wednesday, April 16, 2008 12:58 PM To: AMIT VERMA
Cc: oracle-l
Subject: 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 <http://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 - 18:27:46 CDT