Re: 3000-4000 users on 7.3.4 -- Any advice?

You probably need to look at various issues ..

1. Lots of Memory  and increased PROCESSES,DML_LOCKS settings
2. MTS combined with PreSpawned Dedicated Servers
3. Multiple DBWRs along with CheckPoint Process
4. Redo log Buffers & Latches
5.Most Importantly  Sql Queries..

Run UtlBstat/Estat Scripts against the 1000 user Database and that will tell you where and what to improve....

-Thiru

Michael Benveniste wrote:

> I'm looking to deploy a third party product that doesn't do any connection
> pooling. As a result, there may well be 3000 to 4000 users connections
> to the database during busy times. The good news is that transaction
> rates are fairly low. The bad news is that I'll probably only be able
> to simulate 1000 users for testing. The target server configuration is
> a Sun 4500 running Solaris 2.6.
>
> 1. Given a constant total number and variety of queries and updates, how
> much worse can I expect the system to perform than with, 1000
> connections? Assume I can cover the memory overhead.
>
> 2. What tuning changes would you recommend for such a beast?
>
> Thanks in advance!
> --
> Michael Benveniste -- mike.benveniste_at_fmr.com
>
> Any comments or statements made are not necessarily those of Fidelity
> Investments, its subsidiaries, or affiliates.
Received on Tue Aug 10 1999 - 12:50:23 CDT