Re: swap on solaris8 64 bit for oracle 8i

Gulabchand Jaiswal wrote:
>
> Dirk Kiehne <dirk_at_liberate.com> wrote in message news:<3B40CE2A.7929BB54_at_liberate.com>...
> > Gulabchand Jaiswal wrote:
> > >
> > > Hello All,
> > > Need yourinput....SNIP.........
> > > that solaris8 has some "smart" swap and swapsize of 25 % the size of
> > > RAM is fine !! We have a huge 24 GB RAM domain on an E10K with 64bit
> > > solaris8. We run 32 bit
> > > oracle 8.1.7.1.0. A 6 GB swap on this machine sounds very less.
> > > IS this thing something new ?? or am i too old fashioned to need 1-
> > > 1.5 times the RAM as my swap space ?
> > >
> > > oracle doc id 148673.1 still refers to "2 times the RAM" swap space
> > > for oracle 9i for solaris!
> > > it is not specific with soalris8 though.
> > >
> >
> >
> > I use Solaris 8 exclusively for our DBs and while it may have "smart"
> > swap, in practice 8.1.7.1 still seems to consume alot of swap on my
> > machines.
> >
> > I would stick with (1.5 - 2.0) * RAM. I'm finding at least 50% of my
> > 2*RAM allocation is used up.
> >
> > -Dirk
>
> Dirk..
> Thank you very much for the response. I have some follow-up questions here .
> Appreciate youe help..
>
> - whats ur hardware
> - total RAM
> - SGA sizes
> - how many DBs on songle machine
> - type of DBs( oltp/dss)
>
> TIA..
>
> G

G,

I'm running on the following:

        UE450/2G RAM/1.85G SGA(I know this should be less, but it works)/1DB (OLTP)         UE3500/1G RAM/920M SGA(I know...)/1DB (OLTP)

        Netra1125/512M RAM/400 SGA (I know...)/1DB (OLTP)/Oracle 9i

        etc...

Perhaps because I didn't know about the SGA size guidelines when I otherwise
set everything up to proper standards, is why I'm using more swap but I don't
believe so. I was getting "runnable but swapped" on the UE3500, so I backed of
on the Shared Pool a bit and the problem went away.

My main guideline was to insure that there were no warnings about ISM at the
beginning of the alert_ORCL.log file.

-Dirk Received on Sat Jul 21 2001 - 16:25:24 CDT