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

2001-05-30 Thread Streeter, Lerone A LBX

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



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

2001-05-29 Thread Jared Still


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

2001-05-29 Thread Don Jerman

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

2001-05-29 Thread Kevin Kostyszyn

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

2001-05-29 Thread Ron Rogers

There is a RAM size limit on NT...
With Oracle 8.1.6 on NT there is an option to allow you to use all of the 4 GIG as 
noted in the 8I Administrators Guide for Windows NT section 10. 4GB RAM Tuning (4GT) 
for windows NT server, Enterprise Edition. More information can be found at 
http://www.microsoft.com/ntserver/ntserverenterprise/exec/feature/4gbt.asp 

I hope this info helps. It was a subject of a seminar by Micheal Ault a few months 
ago. Very informative.
ROR mª¿ªm

 [EMAIL PROTECTED] 05/29/01 03:10PM 

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: Ron Rogers
  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

2001-05-29 Thread Jesse, Rich

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

2001-05-29 Thread Eric D. Pierce

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

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

2001-05-29 Thread Eric D. Pierce


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

2001-05-29 Thread TAG DBA

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).
 application/ms-tnef