1000 connections, 8i on NT - any MTS experience?

From: Paul Offord <paul.offord_at_btinternet.com>
Date: Wed, 11 Jul 2001 21:48:08 +0100
Message-ID: <9iifsa$4nv$1@plutonium.btinternet.com>

I am currently helping a customer to troubleshoot some Oracle Financials post-installation problems. At the core of the system they have an Oracle8i database running on an NT4 server. Oracle financials seems to require 2 or sometimes 3 database connections per server. The system needs to support 400 users and so we are expecting 1,000 connections to the database server. Oracle consultants have been on site and tuned the per connection memory requirement down to 5 MB. However, that would still require 5GB - beyond the capabilities of NT.

We are looking at implementing Multi-Threaded Server to bring the memory demands within the capabilities of the NT platform. Oracle UK's experience of an NT site of this size seems limited.

What experience do you have of MTS on NT?
Do you run an Oracle8i server on NT with a similar number of users?

Any experiences, war stories, dos/don'ts would be much appreciated.

Tnaks in advance...Paul Received on Wed Jul 11 2001 - 15:48:08 CDT