RE: help - perf. slow
- From: John Kanagaraj <john.kanagaraj@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 13 May 2004 11:07:59 -0700
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% =
>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
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
