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

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 ?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Crisler, Jon
Sent: Wednesday, July 29, 2009 10:43 AM
To: Don Seiler; mathias.magnusson@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Solaris 10 and Oracle 10g - swap space problem

Yes, I do have sga_max_size set.  

-----Original Message-----
From: Don Seiler [mailto:don@xxxxxxxxx] 
Sent: Wednesday, July 29, 2009 7:54 AM
To: mathias.magnusson@xxxxxxxxx
Cc: Crisler, Jon; oracle-l@xxxxxxxxxxxxx
Subject: Re: Solaris 10 and Oracle 10g - swap space problem

IIRC, lock_sga isn't valid in Solaris.

Jon, do you have sga_max_size explicitly set?  I seem to recall this
behavior on Solaris 10 when sga_max_size was set explicitly.  It
caused us much grief if we set sga_max_size to more than half of the
total physical memory on the box.

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

Other related posts: