High Memory Utilization issue in my system !

[titu]

Hi all ,

I am facing the memory high utilization in the system.

glance show this :

ProcList CPU Rpt Mem Rpt Disk Rpt NextKeys SlctProc Help Exit
Glance C.04.60.000 10:22:23 eorprdma ia64 Current Avg High
------------------------------------------------------------------------------------------------------------
CPU Util SSN | 17% 6% 51%
Disk Util F |100% 22% 100%
Mem Util S UB B | 99% 99% 100%
Swap Util U UR R | 41% 38% 41%



please help on this ...
thanks in advance

titu

[TTr]

You used up all your physical memory. You need to look at
1. what processes are running and if any of them can be turned off
2. what shared memory segments are in use and how big are they and if they are all needed (ipcs -a)
3. Your kernel buffer cache settings
(dbc_mac_pct, dbc_min_pct, it is also shown on glance in the memory bar between the two B's)
4. adding more memory because what you have now is not enough for your environment.

[Patrick Wallek · Accepted solution]

You have 2 options:

1) Decrease RAM usage

2) Add more physical RAM.

Some things you can do to accomplish #1:

a) If your buffer cache is at the default of 50%, reduce it.
b) If this is an Oracle database system, reduce your SGA
c) Don't run so many applications
d) Get users to quit using the system

If some of the suggestions sound ludicrous, that's because there really isn't enough information to give an intelligent recommendation.

You don't say

1)what applications are running
2) what version of HP-UX you are running, though it is probably 11.23 or 11.31 since this is an ia64 system
3) what the user load is like
4) the amount of RAM in the system

If you want more answers, provide more information.

[titu]

Hi all ,

I am using the oracle databse in the system and the value of shmmax shows the output like this :

Tunable Tuning Current Next Boot Default Usage Module
Capability Value Value Value

shmmax Dynamic 1073741824 1073741824 1073741824 100.0% sysv_shm

and the system is inatlled with 11.23 and arond 1000 users are logged in.

Total Ram installed in the server is about 16 GB.

thanks in advance.

titu

[TTr]

You still have to go through the list of items that was given above and identify any memory waste. The shmmax is set to 1GB but you may have several shm segments in use and they are all needed by the database. How big is your SGA? If you reduce the SGA size you database may get slower. 16GB with 1000 oracle users does not sound like it is enough. How many of the 1000 users are concurrent and what are the memory requirements for each user connected to the database. Usually the app that runs on the database specifies these.

[titu]

Thanks for all inputes ,

it helped.

[Siju Vadakkan]

provide the value of dbc_max_pct

#kctune -q dbc_max_pct

and get the memory report from Glance.

thanks siju

[titu]

thanks to all.