Q: What is wrong with Multi-thread server

Oracle 7.0.16.6.1 on DEC OSF/1 with MTS configured as follows:

	MTS_DISPATCHERS="IPC,2"
	MTS_DISPATCHERS="TCP,2"
	MTS_MAX_DISPATCHERS=10
	MTS_SERVERS=4
	MTS_MAX_SERVERS=10
	MTS_SERVICE="sid"

Dispatchers and servers start as expected. The problem is:

         select server from v$session;
tells there are at most one session shown as SHARED, the rest are all shown as NONE (background processes shown as DEDICATED). What's wrong with MST servers ? Why session's server can be NONE ?

And also:

Should MTS_SERVICE be set to sid or service name ? Once I set MTS_SERVICE=service name, all servers shown as DEDICATED.

What is CONNECT_TIMEOUT_LISTENER in listener.ora for ? There is a paragraph in DBA Guide for it, but I can hardly understand what Oracle try to say.

hlu_at_datametrics.com Received on Thu Jun 22 1995 - 00:00:00 CEST