Oracle database server poor performance
741376Jun 19 2010 — edited Jun 19 2010Hi all,
I meet strange problem of mi oracle 9i database on Linux 4 32bit REd hat
the performance is very poor, load average very high (65) for 2 processor quad core (8 virtual processors) the RAm is 4 Gb.
The problem seems memory as the memory usage is 100% from out monitoring tool.
My concerns is when i run vmstat the idle processor is around 65 but Wa is 35. see the output below:
[oracle@cdranalysis ~]$ w
11:28:36 up 8 days, 2:04, 5 users, load average: 67.20, 69.11, 70.11
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root :0 - 11Jun10 ?xdm? 24:33m 0.33s /usr/bin/gnome-session
root pts/1 10.3.4.161 Thu17 41:38m 0.04s 0.01s sqlplus
root pts/2 zdibss3d.celtel. Fri09 26:08 3.60s 3.58s -bash
oracle pts/3 10.3.6.99 11:28 0.00s 0.03s 0.01s w
root pts/5 10.3.4.161 Fri14 18:07m 1.90s 1.89s -bash
[oracle@cdranalysis ~]$ vmstat
procs -----------memory---------- ---swap-- -----io---- system ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
0 2 70084 16456 191812 3415048 1 1 7 247 2 7 8 5 54 33
can anybody help me on how to resolve this problem as it was appearing for while.
Thanks