Re: /etc/system settings for Oracle 9.2

johnleslie_at_madasafish.com (John Leslie) wrote in message news:<4412dd31.0407140642.18abbeb0_at_posting.google.com>...

> What should the /etc/system settings be for Oracle 9.2 on Solaris when
> I have 512MB of physical memory?

512MB isn't very much... but...

Use your favorite calculator to calculate the values - Windows' calc.exe has a nice dec to hex converter. You can use decimal base 10 numbers but I like hex so that's what I put in the file. Either is perfectly fine.

With 512MB you could give 384MB to Oracle leaving some for the OS:

384 * 1024 * 1024 - 1 = 402653183 or 0x17FFFFFF in hex.

Then put this line in /etc/system and reboot:

set shmsys:shminfo_shmmax=0x17FFFFFF

Oracle 10g requires these and they pose no impact so you might as well add these:

• Foil certain classes of bug exploits set noexec_user_stack = 1
• Log attempted exploits set noexec_user_stack_log = 1