Memory Issue

[Madanagopalan S]

I have problem on Memory Usage in my L1000 HPuX 11. The Memory Details

Total VM: 346.7 mb Active VM: 178.4 MB Sys MEM:45.2 MB Buf Cache:35.8MB
User Mem:401.8 MB Free: 29.1MB Phy: 512MB

I have modified the following kernel parameters:
old new
maxuprc 2000 300
maxusers 400 300
ncallout 2064 400
nfile 5000 2000
ninode 5000 2000
nproc 3220 320

now the memory details are :
Total VM:340.6MB Active VM:175.1MB sys MEM:39.1MB User MEM:407.5MB
Buf Cache:26.5MB Free MEM: 38.9MB and PHY: 512MB

My question is , after modifed the kernel parameters, system memory decrases
and user mem is still increasing. How can I limit the user memory. We are using
oracle 8.0.5 database and application 11. There is only 1 user using the machine
for testing. It takes lot of memory and still it increases usage of user memory. HOw can I find out? I am getting lot of deactiviations and page out rates. Pls help me.

[Andy Monks]

It sounds like you've configured the Oracle SGA too high and therefore it's taking too much memory. From the output you gave, I take it you've got glance loaded on the machine. From the glance globals screen, press 's' and then select the pid of the oracle process. You'll be then able to see exactly how much physical and more importantly virtual memory it's using.

You can check the SGA size from hpux pretty well, just doing a 'ipcs -ma' and looking at the 'size' column.

[CHRIS_ANORUO]

As Andy pointed out reduce the size of your SGA's. Then increase shared memory parameters.
I hope you enabled pseudo swapping (swapmem_on=1)
Look at the attached document, it is actually for 10.20.

Cheers!

[Maarten van Maanen]

Hi,

For yor information. There is a book on Oracle 8 & Unix Performance tuning from Ahmed Alomari from Prentice Hall under ISBN 0-13-907676-X.