To see how many dispatchers/shared servers are started up with the RDBMS, check the value of 'mts_dispatchers' and 'mts_servers' in the init.ora. You can also tell by looking in the alert.log(default location is $ORACLE_HOME/rdbms/log). Sample: PMON started DBWR started LGWR started RECO started Thu Sep 14 09:24:15 1995 starting up 4 shared server(s) ... starting up 4 dispatcher(s) for network See Note:1012480.6 on Metastink for mor info on MTS Processes
Dave -----Original Message----- Sent: Wednesday, November 06, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Oracle 8i How can I tell if MTS is activated? Which parameters should I look at? (in init.ora and listener.ora) thanks Pablo _______________________________________________________________ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20Rodriguez?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).