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)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
============================================================================================================
[EMAIL PROTECTED]
.xerox.com To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] 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
> * [EMAIL PROTECTED]
> System Administrator
> _______________________________________________
> sunmanagers mailing list
> [EMAIL PROTECTED]
> http://www.sunmanagers.org/mailman/listinfo/sunmanagers
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Becerril, Mario Henley
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
