| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: help - perf. slow
Also, how many CPUs are on this box?
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"
-----Original Message-----
From: John Kanagaraj [mailto:john.kanagaraj_at_hds.com]=20
Sent: Thursday, May 13, 2004 2:08 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: help - perf. slow
Paula,
>Application server thrashing - and performance for users slow
>
>CPU states: 0.0% idle, 42.8% user, 57.2% kernel, 0.0% iowait, 0.0% =
=3D
>swap
>Memory: 2048M real, 357M free, 1349M swap in use, 1022M swap free
>
> PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
> 27352 oracle 2 26 2 24M 7640K cpu/1 6:48 10.73% httpd
> 20478 oracle 2 16 2 24M 10M run 7:09 10.71% httpd
> 27358 oracle 2 6 2 24M 6768K run 6:41 10.43% httpd
> 27356 oracle 2 6 2 24M 8056K run 7:02 10.17% httpd
> 27355 oracle 2 16 2 24M 7640K run 6:48 9.78% httpd
> 20475 oracle 2 25 2 24M 10M run 7:34 9.61% httpd
> 27353 oracle 2 25 2 24M 7640K run 7:07 9.34% httpd
> 20476 oracle 2 16 2 24M 10M run 7:48 9.27% httpd
> 20477 oracle 2 25 2 24M 10M run 7:33 9.25% httpd
>
>Any advice???? Database server doing nothing BTW.
At first glance, the kernel CPU usage seems very high. This could be due
to
a variety of reasons, including swapping or excessive paging, excessive
number of active processes which induces context switches, excessive
number
of OS calls, etc. The best way to look at this is via 'sar'. Hence, can
you
post the output of 'sar' for -a (file access calls), -c (system calls),
-g
and -p (paging), -k (Kernel ops), -q (queueing), -r (memory) and -u (cpu
usage). Look for high values within...
Hth,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com
 |
 |