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