RE: Problem with many (160 - 170) sessions in the database on
just my input. where are the load metrics documented, meaning where does it say 5M or more per session? i want to know for future reference. we're putting in a solution, oracle 8i on windows 2000/windows 2000 advanced server ~4-to-8G of RAM so there are options if you need additional RAM in excess of 4G. no true *nix expertise here and it's our fledgling implementation but based on specs we should be covered. say it's 10M a session, 500 users is about 5G with plenty left over for O/S, SGA, etc... === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -Original Message- Sent: Wednesday, May 30, 2001 2:11 AM To: Multiple recipients of list ORACLE-L I agree with Goulet. In contrast to ur rather powerful machine my NT server handles abuot 200 connections on a single database with just 1 CPU and 512 MB RAM. Ofcourse preformance is pathetic - but what can one do with Windows anyways ?? I asked management to junk the machine and in a months time we will migrate to a brand new Sun Solaris Server !! The only way we survive with the NT machine is boot it once a week !! Regards -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 10:51 PM To: Multiple recipients of list ORACLE-L Subject:Re:Problem with many (160 - 170) sessions in the database on Jonas, Solution, dump Windows and get onto Linux or buy a real Unix machine. Your asking a toy to do a man/woman's job. Dick Goulet Reply Separator Author: Jonas A Wetterberg [EMAIL PROTECTED] Date: 5/29/2001 8:50 AM Hello We are running into a little problem with an Oracle installation. The server OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server have 4 processes, we have about 1,7 G primary memory and about 2 G of memory on swap disk. We have 4 processes in the machine. One of these is reserved for the OS, and Oracle uses the other 3. We we reach around 170 sessions in the database, the database sometimes goes down and we have to perform a restart. The 3 process Oracle use are all at about 100% in task manager. The memory use is somewhere around 1,3 G. Then we can run the database for aboout 4 more hours, then we have to restart. Sometimes we have to restart around lunch everyday. Now I have heard the Windows NT have a limit of how much memory one process might use, and that limit is somewhere around 1,7 G, and that that might be our problem. We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise Edition or to Windows 2000 Advanced Server. Does anyone know if this can help? Should we put more memory or more processes in the machine? Any help is appreacheated Regards /Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonas A Wetterberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Streeter, Lerone A LBX INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Problem with many (160 - 170) sessions in the database on NT
Jonas, In addition to Dick's comments about a real Os ( with which I concur ) you need to do that math. You are running 170 sessions on the database. You can count on each session eating up 5 meg of RAM with 7.3. If you go to 8i, you can at least double that figure. This is all dependant on your SORT_AREA_SIZE of course and YMMV. So your box is using 1 gig of RAM for user sessions. That leaves you with 700M, and we don't know how big your SGA is. I don't know how much RAM NT wants, maybe someone else can help out here. You need more RAM IMO, but I'm operating on assumptions here and not too many facts. You probably can't upgrade to 8.1.7 with your current RAM. I would wonder about 4 processors for 170 users as well. And of course, there's the 1.7 Gig mem bug you mention, afraid I don't know anything about that. Bottom line, this box seems to be pushing it's resources, but you're in a better position to make that call. Jared On Tuesday 29 May 2001 09:50, Jonas A Wetterberg wrote: Hello We are running into a little problem with an Oracle installation. The server OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server have 4 processes, we have about 1,7 G primary memory and about 2 G of memory on swap disk. We have 4 processes in the machine. One of these is reserved for the OS, and Oracle uses the other 3. We we reach around 170 sessions in the database, the database sometimes goes down and we have to perform a restart. The 3 process Oracle use are all at about 100% in task manager. The memory use is somewhere around 1,3 G. Then we can run the database for aboout 4 more hours, then we have to restart. Sometimes we have to restart around lunch everyday. Now I have heard the Windows NT have a limit of how much memory one process might use, and that limit is somewhere around 1,7 G, and that that might be our problem. We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise Edition or to Windows 2000 Advanced Server. Does anyone know if this can help? Should we put more memory or more processes in the machine? Any help is appreacheated Regards /Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Problem with many (160 - 170) sessions in the database on NT
You should consider running MTS or buying more RAM (if you want to run MTS you probably need to get to 8.1.7.2 first -- I don't remember its status as of 7.3.4 but in the 8.0 and 8.1.pre-7 series it appears to be unreliable). Your problem is probably this: of the 1.7G RAM you really only have about 0.5G available to Oracle, as NT swallows half your RAM for the operating systems' use and then runs services in user-space. If you upgrade to 4GB of RAM and run NT Enterprise Edition you can swing the dividing line and get 3GB for Oracle and 1GB for NT, but otherwise you're stuck with half your RAM for Oracle to share with all the other running programs. I recognize that sometimes we have to run NT because the shop says so, but if you do you have to buy the best box you can get. If you can't get a better one, or you want to make more efficient use of what you have, I must agree with Dick -- learn Unix instead. Jonas A Wetterberg wrote: Hello We are running into a little problem with an Oracle installation. The server OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server have 4 processes, we have about 1,7 G primary memory and about 2 G of memory on swap disk. We have 4 processes in the machine. One of these is reserved for the OS, and Oracle uses the other 3. We we reach around 170 sessions in the database, the database sometimes goes down and we have to perform a restart. The 3 process Oracle use are all at about 100% in task manager. The memory use is somewhere around 1,3 G. Then we can run the database for aboout 4 more hours, then we have to restart. Sometimes we have to restart around lunch everyday. Now I have heard the Windows NT have a limit of how much memory one process might use, and that limit is somewhere around 1,7 G, and that that might be our problem. We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise Edition or to Windows 2000 Advanced Server. Does anyone know if this can help? Should we put more memory or more processes in the machine? Any help is appreacheated Regards /Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonas A Wetterberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
RE: Problem with many (160 - 170) sessions in the database on NT
Actually, I would just try and shrink the sga a little bit and make sure that your swap file is on it's own platter. I have run into a lot of problems with swap file crap on NT, even thought the machine has a gig of ram. Try to keep it just a little below that 1.7 threshold. Also, I read somewhere that the Win2k will allow you to install more ram than NT's limit right now, so the future might be looking a little bit better. -Original Message- Sent: Tuesday, May 29, 2001 3:11 PM To: Multiple recipients of list ORACLE-L NT Jonas, In addition to Dick's comments about a real Os ( with which I concur ) you need to do that math. You are running 170 sessions on the database. You can count on each session eating up 5 meg of RAM with 7.3. If you go to 8i, you can at least double that figure. This is all dependant on your SORT_AREA_SIZE of course and YMMV. So your box is using 1 gig of RAM for user sessions. That leaves you with 700M, and we don't know how big your SGA is. I don't know how much RAM NT wants, maybe someone else can help out here. You need more RAM IMO, but I'm operating on assumptions here and not too many facts. You probably can't upgrade to 8.1.7 with your current RAM. I would wonder about 4 processors for 170 users as well. And of course, there's the 1.7 Gig mem bug you mention, afraid I don't know anything about that. Bottom line, this box seems to be pushing it's resources, but you're in a better position to make that call. Jared On Tuesday 29 May 2001 09:50, Jonas A Wetterberg wrote: Hello We are running into a little problem with an Oracle installation. The server OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server have 4 processes, we have about 1,7 G primary memory and about 2 G of memory on swap disk. We have 4 processes in the machine. One of these is reserved for the OS, and Oracle uses the other 3. We we reach around 170 sessions in the database, the database sometimes goes down and we have to perform a restart. The 3 process Oracle use are all at about 100% in task manager. The memory use is somewhere around 1,3 G. Then we can run the database for aboout 4 more hours, then we have to restart. Sometimes we have to restart around lunch everyday. Now I have heard the Windows NT have a limit of how much memory one process might use, and that limit is somewhere around 1,7 G, and that that might be our problem. We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise Edition or to Windows 2000 Advanced Server. Does anyone know if this can help? Should we put more memory or more processes in the machine? Any help is appreacheated Regards /Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Problem with many (160 - 170) sessions in the database on
There is a RAM size limit on NT... With Oracle 8.1.6 on NT there is an option to allow you to use all of the 4 GIG as noted in the 8I Administrators Guide for Windows NT section 10. 4GB RAM Tuning (4GT) for windows NT server, Enterprise Edition. More information can be found at http://www.microsoft.com/ntserver/ntserverenterprise/exec/feature/4gbt.asp I hope this info helps. It was a subject of a seminar by Micheal Ault a few months ago. Very informative. ROR mª¿ªm [EMAIL PROTECTED] 05/29/01 03:10PM Jonas, In addition to Dick's comments about a real Os ( with which I concur ) you need to do that math. You are running 170 sessions on the database. You can count on each session eating up 5 meg of RAM with 7.3. If you go to 8i, you can at least double that figure. This is all dependant on your SORT_AREA_SIZE of course and YMMV. So your box is using 1 gig of RAM for user sessions. That leaves you with 700M, and we don't know how big your SGA is. I don't know how much RAM NT wants, maybe someone else can help out here. You need more RAM IMO, but I'm operating on assumptions here and not too many facts. You probably can't upgrade to 8.1.7 with your current RAM. I would wonder about 4 processors for 170 users as well. And of course, there's the 1.7 Gig mem bug you mention, afraid I don't know anything about that. Bottom line, this box seems to be pushing it's resources, but you're in a better position to make that call. Jared On Tuesday 29 May 2001 09:50, Jonas A Wetterberg wrote: Hello We are running into a little problem with an Oracle installation. The server OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server have 4 processes, we have about 1,7 G primary memory and about 2 G of memory on swap disk. We have 4 processes in the machine. One of these is reserved for the OS, and Oracle uses the other 3. We we reach around 170 sessions in the database, the database sometimes goes down and we have to perform a restart. The 3 process Oracle use are all at about 100% in task manager. The memory use is somewhere around 1,3 G. Then we can run the database for aboout 4 more hours, then we have to restart. Sometimes we have to restart around lunch everyday. Now I have heard the Windows NT have a limit of how much memory one process might use, and that limit is somewhere around 1,7 G, and that that might be our problem. We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise Edition or to Windows 2000 Advanced Server. Does anyone know if this can help? Should we put more memory or more processes in the machine? Any help is appreacheated Regards /Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Problem with many (160 - 170) sessions in the database on NT
Jonas, We were using Oracle7 on NT for awhile until the major problems just became too unbearable. We would get ORA-600s and corruption constantly. I moved the database over to OpenVMS (I still miss it...) and never had another problem. Good luck! You'll need it! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, May 29, 2001 11:50 To: Multiple recipients of list ORACLE-L Hello We are running into a little problem with an Oracle installation. The server OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server have 4 processes, we have about 1,7 G primary memory and about 2 G of memory on swap disk. We have 4 processes in the machine. One of these is reserved for the OS, and Oracle uses the other 3. We we reach around 170 sessions in the database, the database sometimes goes down and we have to perform a restart. The 3 process Oracle use are all at about 100% in task manager. The memory use is somewhere around 1,3 G. Then we can run the database for aboout 4 more hours, then we have to restart. Sometimes we have to restart around lunch everyday. Now I have heard the Windows NT have a limit of how much memory one process might use, and that limit is somewhere around 1,7 G, and that that might be our problem. We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise Edition or to Windows 2000 Advanced Server. Does anyone know if this can help? Should we put more memory or more processes in the machine? Any help is appreacheated Regards /Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Problem with many (160 - 170) sessions in the database on NT
There are several Oracle tech notes that discuss NT and Windows 2000 Server Memory/Process architecture issues and limitations. I'll look around and post anything I can find quick without having to go back to Metalink. If I recall correctly, Windows 2000 Advanced Server for RAM=4G requires XEON processors. With that, you can also have cpus4. regards, ep On 29 May 2001, at 8:50, Jonas A Wetterberg wrote: ... Now I have heard the Windows NT have a limit of how much memory one process might use, and that limit is somewhere around 1,7 G, and that that might be our problem. We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise Edition or to Windows 2000 Advanced Server. Does anyone know if this can help? Should we put more memory or more processes in the machine? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Problem with many (160 - 170) sessions in the database on NT
http://www.oreview.com/9805harr.htm ---excerpt--- ... On NT, the Oracle instance is implemented as a single NT process. This process includes threads that implement each of the tasks required for the instance. Therefore, there is a thread for each of the background and server tasks plus a two-thread overhead. Because each thread shares the same memory space, there is no need to implement the SGA in shared memory; if you implement the SGA within the instance's process memory, it is available to all threads within the process. Oracle's architecture on NT suits the NT process/thread model. However, the single process model restricts the total memory available to threads belonging to the Oracle instance. Prior to NT version 3.51, the memory limit for a single process was only 256MB--a severe limitation for even moderately sized Oracle instances. In NT version 4.0, a process may address up to 4GB of virtual memory. However, 2GB of this memory is reserved for system overhead, allowing only 2GB for Oracle. At first glance, 2GB might sound like a generous memory allocation for an Oracle instance. But remember that this area of memory must be sufficient to store the SGA and data segments for all Oracle sessions. Furthermore, the 2GB is a virtual memory limit; it's possible that 2GB of virtual memory will be expended when physical memory usage is actually far lower. There are currently two options for extending the 2GB limit: In Windows NT Server Enterprise Edition, you can reduce the system component of process memory to 1GB, allowing up to 3GB of memory for the Oracle instance. On Alpha NT platforms, the very large memory (VLM) option allows up to 8GB of memory to be made available to the Oracle instance. Oracle's multithreaded server option allows multiple client processes to share a smaller number of Oracle server processes. This approach can reduce memory requirements and process overhead. Multithreaded server is also available on NT, but only from Oracle8 onward. Using multithreaded server under Windows NT can reduce the number of threads in the Oracle process as well as overall memory requirements. You may also be able to use the Oracle8 connection pooling and concentrating facilities to further reduce thread and memory overhead. With the release of Windows NT version 5.0 (expected in the fourth quarter of 1998), the process memory limit will increase to 32GB, which should be sufficient for most Oracle installations. ... ---end--- other stuff that may, or may not, contain helpful info: http://www.ipass.net/~davesisk/oont.htm - http://www.geocities.com/tbcox23/ - On 29 May 2001, at 8:50, Jonas A Wetterberg wrote: Date sent: Tue, 29 May 2001 08:50:25 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] We are running into a little problem with an Oracle installation. The server OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server have 4 processes, we have about 1,7 G primary memory and about 2 G of memory on swap disk. We have 4 processes in the machine. One of these is reserved for the OS, and Oracle uses the other 3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Problem with many (160 - 170) sessions in the database on
I agree with Goulet. In contrast to ur rather powerful machine my NT server handles abuot 200 connections on a single database with just 1 CPU and 512 MB RAM. Ofcourse preformance is pathetic - but what can one do with Windows anyways ?? I asked management to junk the machine and in a months time we will migrate to a brand new Sun Solaris Server !! The only way we survive with the NT machine is boot it once a week !! Regards -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 10:51 PM To: Multiple recipients of list ORACLE-L Subject:Re:Problem with many (160 - 170) sessions in the database on Jonas, Solution, dump Windows and get onto Linux or buy a real Unix machine. Your asking a toy to do a man/woman's job. Dick Goulet Reply Separator Author: Jonas A Wetterberg [EMAIL PROTECTED] Date: 5/29/2001 8:50 AM Hello We are running into a little problem with an Oracle installation. The server OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server have 4 processes, we have about 1,7 G primary memory and about 2 G of memory on swap disk. We have 4 processes in the machine. One of these is reserved for the OS, and Oracle uses the other 3. We we reach around 170 sessions in the database, the database sometimes goes down and we have to perform a restart. The 3 process Oracle use are all at about 100% in task manager. The memory use is somewhere around 1,3 G. Then we can run the database for aboout 4 more hours, then we have to restart. Sometimes we have to restart around lunch everyday. Now I have heard the Windows NT have a limit of how much memory one process might use, and that limit is somewhere around 1,7 G, and that that might be our problem. We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise Edition or to Windows 2000 Advanced Server. Does anyone know if this can help? Should we put more memory or more processes in the machine? Any help is appreacheated Regards /Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonas A Wetterberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). application/ms-tnef