HP-UX

To fix an "issue" we're having I need to update SHMMAX from 1GB to 2Gb, it's a dynamic parameter so am just wondering how flexible it really is.

As Oracle is running on the server do I need to shut that down to change the parameter or will it just take the change on the fly?

Also how would I do this from the command line as opposed to the through smh?

Never used smh...

either using command line, either using sam...

And being "Dyanmic" I take it that means that it won't need a recompile or anything it'll just take the new setting on the fly?

Sorry... After the first Quotes, you should have read:
Yes...
So no reboot, instantly after change, will it take account...
What OS version?

Deadly cheers dude!

It's 11.23 so I'll do it through SAM

You may need to adjust "shmmni" and/or "shmseg" . See "glance" option "t" for the current utilisation of both "shmmni" and "shmmax".


In HP-UX 11.11 there was a strange restriction whereby it would only ever allocate 1.75 Gb of shared memory regardless of the kernel maximum.

SMH from command line is equivelent of SAM on v2.
SAM doesn't exist anymore on v3 machines, altho SAM will call SMH actualy

Regarding the kernel parameters, i would reccomend restarting the database after change, altho it should work without.

You can also use kcusage command in this manner which will print the usage in % of maximum in the past 24 hours.
Check man kcusage for more options.

Code:

kcusage -d shmmax

Hope that helps.
Regards
Peasant.