RE: Solaris 10 and Oracle 10g - swap space problem
Date: Mon, 3 Aug 2009 13:09:34 -0400
Here is the info you were looking for-- I was trying to get the SGA up to about 20-30gb but had to settle for about 8-10 gb for now.
# cat release
Solaris 10 8/07 s10s_u4wos_12b SPARC Copyright 2007 Sun Microsystems, Inc. All Rights Reserved. Use is subject to license terms. Assembled 16 August 2007
This machine was Provisioned with a patch cluster released Sep/05/08 using flash archive image "sol10-sun4u-09-15-08.flar".
Platform info from PRTDIAG-
System Configuration: Sun Microsystems sun4u Sun SPARC Enterprise
System clock frequency: 1012 MHz
Memory size: 65536 Megabytes
From: David.J.Miller_at_Sun.COM [mailto:David.J.Miller_at_Sun.COM] Sent: Friday, July 31, 2009 10:26 AM
To: Crisler, Jon
Cc: oracle-l_at_freelists.org; Eberling, James Subject: Re: Solaris 10 and Oracle 10g - swap space problem
What version of S10 are you running? (cat /etc/release). Depending on
the release, there were some issues related to getting large pages for
SGA and the page coalescing process can slow things down a lot if there aren't many large pages available. There is a Sun Infodoc talking about that I believe. I can find it if you can't.
What hardware platform is this?
Swap shouldn't need to be initialized. It just gets allocated/reserved
case it's needed. And that really doesn't take very long, so I can't believe that's the reason for the slow startup.
How big is your SGA? Larger SGAs will take longer to start but that's
related to swap at all. And if the page coalescing daemon is needed, it can slow things down even more.
And have you looked at "pmap -xs PID" for the lgwr PID to be sure you're
2M (x64) or 4M (SPARC) pages? Does it say "DISM" or "ISM" for those?
Crisler, Jon wrote, On 07/30/09 09:57:
> I played around extensively with sga_max_size, sga_target, DISM and
> related settings etc. without success- whatever I do for oracle shared
> memory segments gets mapped to swap space. Also, instance startup
> to be really slow due to the swap initialization, but once the
> is running it seems fine. I have not found much on Metalink
> this issue- does anybody have a Metalink or Sun technote that
> this issue ?