topic Re: memory management in Operating System - HP-UX

memory management

lou frati — Thu, 05 Mar 2009 17:16:29 GMT

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

Re: memory management

Steven E. Protter — Thu, 05 Mar 2009 17:19:16 GMT

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

Re: memory management

James R. Ferguson — Thu, 05 Mar 2009 17:37:47 GMT

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...

Re: memory management

Mark Coffey_2 — Fri, 06 Mar 2009 03:38:53 GMT

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.

Re: memory management

Wim Rombauts — Fri, 06 Mar 2009 07:44:57 GMT

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 ?

Re: memory management

lou frati — Fri, 06 Mar 2009 12:29:22 GMT

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

Re: memory management

Dennis Handly — Fri, 06 Mar 2009 20:11:12 GMT

>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?

Re: memory management

lou frati — Fri, 06 Mar 2009 20:31:22 GMT

yes, that would be helpful.

thanks,
lrf

Re: memory management

Avinash20 — Fri, 06 Mar 2009 20:35:21 GMT

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.

Re: memory management

Avinash20 — Fri, 06 Mar 2009 20:35:44 GMT

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.

Re: memory management

Avinash20 — Fri, 06 Mar 2009 20:38:26 GMT

Also this itrc url will be useful, just in case if you face issue with oracle installation on 11.31

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1255000

Re: memory management

lou frati — Fri, 06 Mar 2009 20:46:02 GMT

once again good info, our DBA has been in contact with Oracle and is aware of the supported versions.

Re: memory management

Avinash20 — Fri, 06 Mar 2009 20:47:53 GMT

Hi,

Please assign points to this thread if you find it helpful !!

Re: memory management

Court Campbell — Fri, 06 Mar 2009 21:18:47 GMT

I would suggest buying a glance plus license. It's really a great utility. Without it it may be difficult to find out how much memory is being used by the UFC.

Re: memory management

lou frati — Fri, 06 Mar 2009 21:23:00 GMT

we've been looking into glance and since you mentioned it that is probably what is needed.
I've used the trial release and it provided alot of good info.

thanks all,