How Do you Explain Account Memory Use on HPUX11i Systems?

[Alzhy]

Anyone has come up with a successful "recipe" yet in outlining a server's memory (physical) usage? Ie. in lay terms - definitively and illutratively say:

Oracle uses 4GB because DB Instance 1's SHM usage is 1.2GB, each DB connection uses 25MB.. etc.

Can summing up SZ for each app/system group equate to cming up with what I need? What about Shared Memory and its relation to SZ? On Solaris environments.. ps shows an Oracle process' SHM usage by the very fact that an Oracle for/background process VSS is equal to SGA (which is essentially a SHMSEG)

Also, is there an advantage on turning on "memory swap" on 11i systems? It seems to be on by default:

root@express # swapinfo -atm
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4096 159 3937 4% 0 - 1 /dev/vg00/swap
dev 8192 154 8038 2% 0 - 1 /dev/vg00/swap2
dev 16384 160 16224 1% 0 - 1 /dev/vg00/swap3
reserve - 21002 -21002
memory 9361 1662 7699 18%
total 38033 23137 14896 61% - 0 -
root@express # memstat
Memory Stat total used avail %used
physical 12288.0 11731.4 556.6 95%
active virtual 22200.1 4344.2 17855.9 20%
active real 9123.7 2800.5 6323.1 31%
memory swap 9361.3 1662.3 7698.9 18%
device swap 28672.0 21474.5 7197.5 75%

[Steve Steel]

Hi

try /usr/share/doc/mem_mgt.txt


Steve Steel

[Alzhy]

Steve.. thanks but no such document exists on all my 11i installs.

[Pete Randall]

Nelson/Steve,

That's an 11.0 doc (attached).


Pete

[Alzhy]

Thanks Pete, but this is a rather old document... Has there been any significant changes between 11.0 and 11i in terms of veirtual memory management?

What I am actually after is a simple process to show how memory can be portrayed as being used or a tool that will do exactly that.

Unfortunately, even those expensive commercial tools do not easily answer questions relating to memory usage... It is just that we have to satisfy a need for someone that has been bugging as to effectively portray how memory is being used among the apps before money is allocated...

[Pete Randall]

Nelson,

Here's a TKB doc (4000027449) that describes the 11.0/11i differences:

http://www1.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000066954544


Pete

[Pete Randall]

Nelson,

And here's a more current version of the memory management white paper itself:

http://docs.hp.com/cgi-bin/otsearch/getfile?id=/hpux/onlinedocs/os/11i/mem_mgt.html&searchterms=5965-4641&queryid=20030128-153709


Pete

[Alzhy]

Graci Pete.. this will be good reading to some of our truly UNIX savvy application developers..