Re: quick linux memory question
Date: Mon, 31 Mar 2014 14:51:31 -0400
Message-Id: <4668308C-E09D-4E3D-9BF5-485C0A2AA1B2_at_gmail.com>
I would say both are a little small considering the amount of memory on the host depending on the servers use case. Also, I would expect SHMALL ( * pagesize ) to be higher than SHMMAX since SHMALL is total system wide shared memory and SHMMAX is the maximum size of any single segment.
If not already you might also want to look into huge pages, especially if you’re running a large SGA and a large number of connections.
On Mar 31, 2014, at 2:40 PM, Sweetser, Joe <JSweetser_at_icat.com> wrote:
> All -
>
> Red Hat Enterprise Linux Server release 5.8 (Tikanga)
> Oracle 11.1 and 11.2 databases
> 252gb main memory
> Page_size = 4096 (bytes)
> Shmmax = 76800000000 (bytes)
> shmall = 4194304 (pages)
>
> I am sort of referencing Doc ID 301830.1
>
> So, shmmax is about 71.5gb and shmall is currently set to use up to 16gb of 'SGA' space (my term).
>
> Sanity check: any issue with setting shmall to something like 15728640 (60gb)? Still well below physical memory and somewhat below shmmax, but I have never set shmall that high so just curious if there any gotchas.
>
> ADVthanksANCE,
> -joe
>
> Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 31 2014 - 20:51:31 CEST