memory management

[lou frati]

Hi,
I can't seem to find a good resource for memory management on hp-ux v11.31.
Could someone point me in the right direction.
Also, we are installing oracle 9.2.0 for hp-ux 11.31 and the people at oracle could not give a good set of directions for what kernel parameters to modify.

thanks,

lrf

[Steven E. Protter]

Shalom,

To know what is using what, try this tool. I wrote it:

http://www.hpux.ws/?p=8

For actual management and optimization, HP has a pay for add in program called WLM

SEP

[James R. Ferguson]

Hi:

You might find this white-paper useful:

http://docs.hp.com/en/5992-4222ENW/5992-4222ENW.pdf

Appendix-A speaks specifically about Oracle.

Regards!

...JRF...

[Mark Coffey_2]

The Process Resource Manager (PRM) has memory management functionality available such that you can control the amount of memory available to a specific application. The WLM product mentioned above is built on top of PRM and adds additional CPU resource management functionality. For more information about PRM, checkout the http://www.hp.com/go/prm site. There are whitepapers describing use cases where PRM's memory management functionality was used to isolate an Oracle database instance and achieve high levels of transaction throughput.

Note that for the more recent HP-UX 11.31 Base/Foundation OEs, the PRM is included in the license.

[Wim Rombauts]

PRM and WLM are rather useless for Oracle.
First of all, they can limit private memory for oracle, but shared memory (like the SGA) is taken from the PRM_SYS (root) resource group, not from the one you would define for Oracle.

Further : You can specify perfectly what amount of memory Oracle is allowed to use : SGA, PGA, ...

So, what eactly is it that you want to do ?

[lou frati]

I would like to thank everyone that has responded so far, all info has helped especially the kernel parms in the HP doc sent by Steve Ferguson.
One more thing, is there a better quick way of seeing memory usage other than swapinf -tm?

thanks again for all the info.

lrf

[Dennis Handly]

>is there a better quick way of seeing memory usage other than swapinfo -tm?

What would you like in "better", more details like the file cache?

[lou frati]

yes, that would be helpful.

thanks,
lrf

[Avinash20]

Please refer to

http://download.oracle.com/docs/cd/E11062_01/install.1023/e11057/avgnt_preinstall.htm#CBHEFJIG

Also oracle comes with a pre-install script which automatically checks for the kernel parameter and patches.

[Avinash20]

The following Kernel Parameters are obsolete on HP-UX 11i v3 (11.31):

maxswapchunks
msgmap
ncallout
semmap
vx_ncsize

Hence, if the pre-install script is not updated, and if it throws error for above kernel paramater not set, then simply ignore it.