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
