High memory usage

[manamirhastam]

Hello guys
I'm using Oracle RAC10g on HP-UX V2.
The usage of memory is too high.

Glance output :
CPU 18% 18% 18%
Disk 52% 52% 52%
Mem 97% 97% 97%
Swap 84% 84% 84%

#vmstat :

procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
2 1 0 1173615 58333 509 159 4 4 0 0 51 1854 70047 1187 8 2 89



#swapinfo -tam
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4096 1145 2951 28% 0 - 1 /dev/vg00/lvol2
dev 4096 1149 2947 28% 0 - 1 /dev/vg00/lvol3
reserve - 5880 -5880
memory 8180 5739 2441 70%
total 16372 13913 2459 85% - 0

What your idea about memory usage ?

[A. Clay Stephenson]

If you are running the default dbc_max_pct value of 50% then reduce it so that it is down in the 10% or so range.

Note your po (pageout) column in vmstat, it's not very big but it's not zero. Ideally, you want that value at 0 all the time.

You have a few options: 1) Add more memory 2) Reduce buffer cache 3) Reduce the size of the SGA.

Above all, reducing the size of the SGA is far better by a factor of at least 100 than allowing the system to pageout to any significant degree.