1847365 Members
4468 Online
110264 Solutions
New Discussion

Re: Memory Window

 
Karen Lee
Occasional Contributor

Memory Window

How do I make use of Memory Window in ver 11.0.


Thanks
Karen
4 REPLIES 4
Dan Hetzel
Honored Contributor

Re: Memory Window

Hi Karen,

This should give you a good starting point:

http://europe-support2.external.hp.com/cki/bin/doc.pl/sid=bb4557881d48823641/screen=ckiDisplayDocument?docId=200000048912928

Regards,

Dan
Everybody knows at least one thing worth sharing -- mailto:dan.hetzel@wildcroft.com
CHRIS_ANORUO
Honored Contributor

Re: Memory Window

If you are running Oracle 32-bit you will not be able to address more than 1.87 GB of shared memory (which happens to be the limit for shared memory on 32 bit 10.20 of HP-UX). This would not be the problem if you were running 64-bit oracle. You can get around this problem (with 32-nit Oracle) by limiting your TOTAL SGA usage to less than approx. 1.8GB of SGA space. Alternatively you can implement what is known as memory windows on HP-UX 11 that will allow each instance to utilize up to 1.87 GB of SGA space.

There is a patch, PHCO_20443 for 11.
When you install it there is detailed document all about memory windows in /usr/share/doc/mem_wndws.txt
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
KarenLee
New Member

Re: Memory Window

Hi Dan,

Thanks for your reply but I am not able to
access the link as mentioned.

Any other sites that I can try.

Rgds
Karen
Dan Hetzel
Honored Contributor

Re: Memory Window

Hi Karen

Funny, because a click on the link worked for me.

You'll find a text only version of the
Document KBAN00000306 here attached

Best regards,

Dan
Everybody knows at least one thing worth sharing -- mailto:dan.hetzel@wildcroft.com