Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

SHMMAX NEW VALUE

dst
Occasional Contributor

SHMMAX NEW VALUE

We have Oracle database 9i with 1.4 GB (640 mb share pool and 640 mb in share pool )of SGA 5 GB in HPUX 11i (RP3400) with 4 GB of total memory but i have 300 mb of memory free
and SHMMAX of 67108864 I want to have 12 GB of memory RAM, whit 4 GB OF SGA, what should be the new value of SHMMAX,and share pool,share pool? i have only one instance transactional
2 REPLIES
Tim Nelson
Honored Contributor

Re: SHMMAX NEW VALUE

shmmax can be set to physical memory this parameter is only a limiter.

Set it to 12GB.
TwoProc
Honored Contributor

Re: SHMMAX NEW VALUE

Well, the max you'll need is the size of the db_cache_size. It can be smaller than this number, but if you make it at least the size of db_cache_size, it will all fit in a single segment. While the database can handle up to 6 or 7 segments for this purpose efficiently, it is most efficient at handling a single one.

So, I'd set it to just a bit larger than what the db_cache will be. You could go ahead and set it at next reboot, you shouldn't need to wait for the ram to get this put in, if it would be better for scheduling to get as much in as you can now.
We are the people our parents warned us about --Jimmy Buffett