Oracle-L: Dedicated server to MTS changeover

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 28 Apr 2003 09:06:41 -0800
Message-ID: <F001.0058AA03.20030428090641@fatcity.com>

On moving Database from Dedicated server Oracle connections to MTS what may be the best practices , performance parameters , suggested tuning ?

Following is our strategy for your perusal :-

There are about 3000 concurrent dedicated server connection processes to the Database before moving to MTS .

6 Listener processes (remains unchanged moving from Dedicated server to MTS) MTS_DISPATCHERS=15 per listener
Therefore the total number of dispatchers for 6 listeners = (15 * 6) = 90 MTS_SERVERS=400 ( 3000 / 10 approx.) (Number of shared servers to spawn on database startup) MTS_MAX_SERVERS=1000
LARGE_POOL_SIZE = 1400 MB ( MTS_SERVERS * 3.5 MB i.e. 400 * 3.5 MB ) SESSIONS = 50 (MAX. 50 User processes handled per Dispatcher ) shared_pool_size increased to 150 MB from 115 MB to handle additional info. written to shared pool in MTS mode

Thanks

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Mon Apr 28 2003 - 12:06:41 CDT