Re: maxing sys mem for Oracle

The documentation does not tell you anything. All it tell you is the default values for one instance on the machine. I have 4 DB instances. Also the docs do not tell you what the max values can be for these fields.......there are several system scripts that can be run but there more or less for the init.ora file parameters.....

-Javier

In article <87phhl$lt8$1_at_bob.news.rcn.net>,   "Eugene Firyago" <efiryago_at_bisys.com> wrote:
> See Oracle Server for Solaris Installation Guide. You'll find there
the
> directions on how to properly adjust unix kernel parameters depending
on
> number of instances and init.ora parameters.
>
> <javierg_at_acm.org> wrote in message news:87pgbd$no4$1_at_nnrp1.deja.com...
> > Currently running oracle 7.3.3 on Solaris 2.6 with 512MB
> > running on a Sun 250. I am running 4 database instances
> > I wish to know how high I can set these values w/o messing
> > it up to the point that it will not reboot.
> >
> > set shmsys:shminfo_shmmax=393216000
> > set shmsys:shminfo_shmmin=1
> > set shmsys:shminfo_shmmni=100
> > set shmsys:shminfo_shmseg=30
> > set semsys:seminfo_semmns=1000
> > set semsys:seminfo_semmni=350
> > set semsys:seminfo_semmsl=350
> >
> > TIA
> > -Javier
> > Javier.Gonzalez_at_scott.af.mil
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 09 2000 - 00:01:31 CST