Re:Problem with many (160 - 170) sessions in the database on

From: <dgoulet_at_vicr.com>
Date: Tue, 29 May 2001 09:50:34 -0700
Message-ID: <F001.0031217E.20010529092109@fatcity.com>

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 <jonas.a.wetterberg_at_manpower.se>
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: jonas.a.wetterberg_at_manpower.se

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------