| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Solaris /etc/system values for Oracle8i
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).Received on Fri Sep 26 2003 - 18:54:44 CDT
 |
 |