RE: Solaris 10 and Oracle 10g - swap space problem

From: Crisler, Jon <Jon.Crisler_at_usi.com>
Date: Mon, 3 Aug 2009 13:09:34 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB067504B4B09D_at_mds3aex08.USIEXCHANGE.COM>

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 M5000 Server
System clock frequency: 1012 MHz
Memory size: 65536 Megabytes

8 CPU's

-----Original Message-----
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

Hi Jon,

What version of S10 are you running? (cat /etc/release). Depending on the release, there were some issues related to getting large pages for the
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 in
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 not
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 getting
2M (x64) or 4M (SPARC) pages? Does it say "DISM" or "ISM" for those?

Regards,

Dave Miller

Crisler, Jon wrote, On 07/30/09 09:57:
> I played around extensively with sga_max_size, sga_target, DISM and
ISM
> related settings etc. without success- whatever I do for oracle shared
> memory segments gets mapped to swap space. Also, instance startup
seems
> to be really slow due to the swap initialization, but once the
instance
> is running it seems fine. I have not found much on Metalink
addressing
> this issue- does anybody have a Metalink or Sun technote that
addresses
> this issue ?
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 03 2009 - 12:09:34 CDT