1747984 Members
4922 Online
108756 Solutions
New Discussion юеВ

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