Re: Solaris /etc/system values for Oracle8i
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. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 29, 2003 5:34 PM 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) [EMAIL PROTECTED] [EMAIL PROTECTED] tanel.poder.00 [EMAIL PROTECTED]To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] wrote: What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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) [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
Re: Solaris /etc/system values for Oracle8i
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) [EMAIL PROTECTED] [EMAIL PROTECTED] tanel.poder.00 [EMAIL PROTECTED]To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] wrote: What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] .xerox.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Solaris /etc/system values for Oracle8i
RE: Solaris /etc/system values for Oracle8i
Check out doc ID 15566.1 at Metashlink. -Original Message- [mailto:[EMAIL PROTECTED] 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) [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cunningham, Gerald 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).
RE: Solaris /etc/system values for Oracle8i
Just wanted to jump in a bit here. I have 4 oracle instances running on a solaris box with 2GB of RAM. My available memory hovers at a little more than 1 GB free. Swap size isn't really a factor, unless you are actively swapping, which we are not. Now granted the largest of these instances has a SGA footprint of about 200MB. While we are not talking about large databases, I think I could easily drop 4 more smallish DBs out there. Now I admit, that if I needed to do this this, I would also request additional memory, but that is just my nature, not a real requirement. oh and since you did ask about swap size in Tanel's case, our swap slice is 2GB we rarely use more than 500MB of swap. Steve McClure -Original Message- [EMAIL PROTECTED] Sent: Monday, September 29, 2003 7:35 AM To: Multiple recipients of list ORACLE-L 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) [EMAIL PROTECTED] [EMAIL PROTECTED] tanel.poder.00 [EMAIL PROTECTED]To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] wrote: What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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) [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
Re: Solaris /etc/system values for Oracle8i
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 [EMAIL PROTECTED] wrote: What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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) [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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
Re: Solaris /etc/system values for Oracle8i
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] wrote: What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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) [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
Re: Solaris /etc/system values for Oracle8i
What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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) [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
Re: Solaris /etc/system values for Oracle8i
Precisely! Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 28, 2003 12:54 AM What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, September 27, 2003 2:54 AM 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] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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).
RE: Solaris /etc/system values for Oracle8i
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:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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) [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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). winmail.dat
Solaris /etc/system values for Oracle8i
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).
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) [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).