Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Solaris /etc/system values for Oracle8i

Re: Solaris /etc/system values for Oracle8i

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sun, 28 Sep 2003 17:29:39 -0800
Message-ID: <F001.005D14FB.20030928172939@fatcity.com>


Yep, I have development and even small production 8i instances which take only about 100MB of memory (SGA, listener, dispatcher, shared servers).

Tanel.

> I've a customer running a development environment of two OraApps 11.5.8
> database instances and one more database instance (for web development
under
> WebLogic), all on a Sun V100.
>
> Yes, that is a rack-mountable Solaris machine of 1U rack height with a
> maximum configuration of one (1) UltraSPARC-III CPU, 1.0 Gb of RAM, and
> three 36-Gb HDD. Main storage is a NAS (since the machine doesn't
> accommodate SCSI or FC adapters).
>
> Foolishly underconfigured, yes. Impossible or difficult, no.
>
>
>
> on 9/27/03 7:54 AM, Tanel Poder at tanel.poder.003_at_mail.ee wrote:
>
> > What the heck was that?
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Saturday, September 27, 2003 2:54 AM
> >
> >
> >>
> >> Mario:
> >>
> >> If you are using Solaris with 2GB of memory, it will be awfully
difficult,
> >> if not impossible, to run 6 instances of Oracle8i simultaneously.
> >> Basically, because of the use of semaphores and the way Solaris manages
> >> memory, I would say you could run 3 or 4 instances , depending on their
> >> size. But to have all six up and running, especially if you have to
> > create
> >> them, will not work. Oracle usually needs 1 GB per instance while you
are
> >> creating a database. While running it, you would not necessarily need
> > that
> >> much. I advice you to upgrade the memory on the server to 8 GB. I
suggest
> >> you budget 1 GB per Oracle instance.
> >>
> >> RWB
> >>
> >>
> >



> > ================================
> >>
> >> Reginald W. Bailey
> >> IBM Global Services - ETS SW GDSD - Database Management
> >> Your Friendly Neighborhood DBA
> >> 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
> >> reginald.w.bailey_at_jpmorgan.com
> >> baileyre_at_us.ibm.com
> >>
> >


> > ================================
> >>
> >>
> >>
> >> Mario.H.Becerril_at_mex
> >> .xerox.com To:
> > ORACLE-L_at_fatcity.com
> >> Sent by: cc:
> >> ml-errors_at_fatcity.co Subject: Solaris
> > /etc/system values for Oracle8i
> >> m
> >>
> >>
> >> 09/26/2003 06:19 PM
> >> Please respond to
> >> ORACLE-L
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>> Hi managers.
> >>>
> >>> I need modify /etc/systems parameters in my e450 box, it allow 6
> >> instances
> >>> for oracle 8i
> >>>
> >>> Box have 2 GB in RAM
> >>>
> >>> Next values are valid???
> >>> SHMMAX 0.5*(physical memory present in machine)
> >>> SHMMIN 1
> >>> SHMMNI 100
> >>> SHMSEG 10
> >>> SEMMNI 100
> >>> SEMMSL Set to 10 plus the largestinitsid.ora PROCESSES parameter of an
> >>> Oracle database on the system.
> >>> SEMMNS Set to the sum of the PROCESSESparameter for each Oracle
database
> >>> except the largest one, plus 2 timesthe largest PROCESSES value, plus
10
> >>> times the number of Oracle databases.
> >>> SEMOPM 100
> >>> SEMVMX 32767
> >>>
> >>> Mario Henley Becerril Geldis
> >>> * (52) +55 5326 3200 ext. 1588
> >>> * Mario.H.Becerril_at_mex.xerox.com
> >>> System Administrator
> >>> _______________________________________________
> >>> sunmanagers mailing list
> >>> sunmanagers_at_sunmanagers.org
> >>> http://www.sunmanagers.org/mailman/listinfo/sunmanagers
> >>>
> >> --
> >> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >> --
> >> Author: Becerril, Mario Henley
> >> INET: Mario.H.Becerril_at_mex.xerox.com
> >>
> >> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >> San Diego, California -- Mailing list and web hosting services
> >> ---------------------------------------------------------------------
> >> To REMOVE yourself from this mailing list, send an E-Mail message
> >> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >> the message BODY, include a line containing: UNSUB ORACLE-L
> >> (or the name of mailing list you want to be removed from). You may
> >> also send the HELP command for other information (like subscribing).
> >>
> >>
> >>
> >> --
> >> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >> --
> >> Author:
> >> INET: Reginald.W.Bailey_at_jpmorgan.com
> >>
> >> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >> San Diego, California -- Mailing list and web hosting services
> >> ---------------------------------------------------------------------
> >> To REMOVE yourself from this mailing list, send an E-Mail message
> >> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >> the message BODY, include a line containing: UNSUB ORACLE-L
> >> (or the name of mailing list you want to be removed from). You may
> >> also send the HELP command for other information (like subscribing).
> >>
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tim Gorman
> INET: tim_at_sagelogix.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sun Sep 28 2003 - 20:29:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US