RE: Solaris /etc/system values for Oracle8i

From: Cunningham, Gerald <Gerald.Cunningham_at_usi.net>
Date: Mon, 29 Sep 2003 07:55:02 -0800
Message-ID: <F001.005D15FC.20030929075502@fatcity.com>

Check out doc ID 15566.1 at Metashlink.

-----Original Message-----
[mailto:Reginald.W.Bailey_at_jpmorgan.com] Sent: Friday, September 26, 2003 7:55 PM To: Multiple recipients of list ORACLE-L

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: Cunningham, Gerald
  INET: Gerald.Cunningham_at_usi.net

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 Mon Sep 29 2003 - 10:55:02 CDT