RE: Solaris /etc/system values for Oracle8i

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Sat, 27 Sep 2003 09:34:40 -0800
Message-ID: <F001.005D14B7.20030927093440@fatcity.com>

That's what I said. :) I gotta go check my database I ran under Linux under VMware on my laptop. Maybe it didn't get created at all, I dreamed it all up!

-----Original Message-----

From:	Tanel Poder [mailto:tanel.poder.003_at_mail.ee]
Sent:	Sat 9/27/2003 10:54 AM
To:	Multiple recipients of list ORACLE-L
Cc:	
Subject:	Re: Solaris  /etc/system values for Oracle8i

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: 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).






Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.

------_=_NextPart_001_01C38514.F89C6608--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: Richard.Ji_at_ztango.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).



application/ms-tnef attachment: winmail.dat

Received on Sat Sep 27 2003 - 12:34:40 CDT