cancel
Showing results for 
Search instead for 
Did you mean: 

memory management

SOLVED
Go to solution
lou frati
Occasional Contributor

memory management

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
14 REPLIES
Steven E. Protter
Exalted Contributor

Re: memory management

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
James R. Ferguson
Acclaimed Contributor

Re: memory management

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

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
Honored Contributor

Re: memory management

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
Occasional Contributor

Re: memory management

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
Acclaimed Contributor

Re: memory management

>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
Occasional Contributor

Re: memory management

yes, that would be helpful.

thanks,
lrf
Avinash20
Honored Contributor

Re: memory management

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.

"Light travels faster than sound. That's why some people appear bright until you hear them speak."
Avinash20
Honored Contributor

Re: memory management

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.
"Light travels faster than sound. That's why some people appear bright until you hear them speak."
Avinash20
Honored Contributor

Re: memory management

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
"Light travels faster than sound. That's why some people appear bright until you hear them speak."
lou frati
Occasional Contributor

Re: memory management

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

Re: memory management

Hi,

Please assign points to this thread if you find it helpful !!
"Light travels faster than sound. That's why some people appear bright until you hear them speak."
Court Campbell
Honored Contributor
Solution

Re: memory management

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.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
lou frati
Occasional Contributor

Re: memory management

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,