Re: Value for MTS_MAX_DISPATCHERS and MTS_MAX_SERVERS

From: tim london <tim_at_artemis.demon.co.uk>
Date: Sat, 4 Feb 1995 18:08:32 +0000
Message-ID: <215713281wnr_at_artemis.demon.co.uk>


In article: <3fnql0$lsm_at_raffles.technet.sg> scornd11_at_technet.sg (Nicholas Wee) writes:

> What are some of your tuning parameters for large ORACLE systems
> such as those that support up to 800 ORACLE sessions assuming that
> at least 400 of these sessions are busy at any one time ???
>
> What would u set for MTS_MAX_DISPATCHERS and MTS_MAX_SERVERS for
> a reasonably fast SINGLE CPU HP UNIX box with 128MB RAM running
> Oracle 7.1 ???
>

        I normally suggest the following to initially set up the system

        MTS_MAX_DISPATCHERS = Max concurrent users / 20

        MTS_MAX_SERVERS = Max concurrent users / 10

        Then monitor the system for a few days.

-- 

---

	Tim L
Received on Sat Feb 04 1995 - 19:08:32 CET

Original text of this message