Re: Problem with many (160 - 170) sessions in the database on NT
I'm going to retract part of this post, as it has been pointed out to me that 7.3 on NT normally consumes about 1.5 meg of RAM per session. This is of course dependent on SORT_AREA_SIZE. I've obviously disremembered common memory usage stats for 7.3.x. That and a lot of my 7.3 experience in on a DW where the sessions used quite a bit more memory that 1.5 Meg. Jared On Tuesday 29 May 2001 12:10, Jared Still wrote: > 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
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 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 cpus>4. 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
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
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 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
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).