RE: Solaris 10 and Oracle 10g - swap space problem
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <Jon.Crisler@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 31 Jul 2009 13:09:52 -0400
ZFS Tunning might be relative to your situation.
You can limit the amount of memory ZFS reserves for the file system.
It was reserving about 11Gbs on our system. (of 32Gbs, solaris 5.10
T1000), It has been lowered to 2Gbs, and this weekend again it will be
lowered to 1Gb.
Thinks like logging in are now much faster. It used to be that when
you start anything it took awhile.
So the idea is for it the cache the file system, and it is supposed to
give up the memory if something else needs it, but what does it have to
do to find memory for the processes that are starting... over and
over... That is the question.
Cat /etc/system
set zfs:zfs_arc_max=0x80000000
Let me know. (Most of this is 'sysadmin' stuff so you might want to
google or ask around for more info on it).
We use DISM, and I find it convenient, certainly moreso than managing
the pools on all my databases, I just don't have the cycles for that.
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Crisler, Jon
Sent: Thursday, July 30, 2009 10:58 AM
To: oracle-l@xxxxxxxxxxxxx
Cc: Eberling, James
Subject: 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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
