| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 Rich.Jesse_at_qtiworld.com 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: Rich.Jesse_at_qtiworld.com
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: ListGuru_at_fatcity.com (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). Received on Tue May 29 2001 - 15:20:36 CDT
 |
 |