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: Mon, 29 Sep 2003 06:59:46 -0800
Message-ID: <F001.005D15EB.20030929065946@fatcity.com>


Hi!

What are you trying to tell me?
I am already running my 100MB instances, this is completely irrelevant to my swap space size.

Tanel.

>
> Tanel:
>
> How large is the swap file? For Oracle usage, maximum memory settings in
> the /etc/system file are based on total memory available, or REAL memory.
> This would be physical memory + swap file space (virtual memory). So, with
> 1GB of physical memory, and an equal amount or more of swap space, you
> could run it the way you have configured it.
>
>
>




>
> 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
>



>
>
>
> tanel.poder.00
> 3_at_mail.ee To: ORACLE-L_at_fatcity.com
> Sent by: cc:
> ml-errors_at_fatc Subject: Re: Solaris
/etc/system values for Oracle8i
> ity.com
>
>
> 09/28/2003
> 08:29 PM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
> Yep, I have development and even small production 8i instances which take
> only about 100MB of memory (SGA, listener, dispatcher, shared servers).
>
> Tanel.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Sunday, September 28, 2003 11:59 PM
>
>
> > 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).
>
>
>
> --
> 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).
Received on Mon Sep 29 2003 - 09:59:46 CDT

Original text of this message

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