Value for MTS_MAX_DISPATCHERS and MTS_MAX_SERVERS
From: Nicholas Wee <scornd11_at_technet.sg>
Date: 20 Jan 1995 08:01:36 GMT
Message-ID: <3fnql0$lsm_at_raffles.technet.sg>
Singapore 1024
Singapore
Received on Fri Jan 20 1995 - 09:01:36 CET
Date: 20 Jan 1995 08:01:36 GMT
Message-ID: <3fnql0$lsm_at_raffles.technet.sg>
Hello Oracle Experts !
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 ???
Any replies and stories on ORACLE PERFORMANCE TUNING welcomed !!! Will summarise. Thanks !
Nicholas Wee EMAIL: scornd11_at_technet.sgComputer Systems Info, Inc
Singapore 1024
Singapore
Received on Fri Jan 20 1995 - 09:01:36 CET