Re: Oracle/Solaris Kernel Tunables Question

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 25 Mar 2003 10:00:44 +0800
Message-ID: <3E7FB84C.1A60@yahoo.com>

Chuck wrote:
>
> We are moving from a 4GB Solaris 8 64-bit box to a 10GB box, does it
> make sense to increase the shmmax parameter?
>
> Currently we have:
> set shmsys:shminfo_shmmax=2097152000
>
> Does this line limit the SGA to 2 GB?
>
> Thanks,
> CC
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

It limits the size of a single segment to 2G but Oracle can use multiple segments without any great problems. There used to be reports that Oracle could not could not use Solaris's ism unless it was in a single segment but I'm unsure of the truth of that one

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"

Received on Mon Mar 24 2003 - 20:00:44 CST