Re: Q: What is wrong with Multi-thread server

Call Oracle support and ask for bulletins 105771.313 and 107067.569. The info in these bulletins helped me.
>==========Huarong Lu, 6/22/95==========
>
>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"
>and three MTS_LISTENER_ADDRESS for IPC/sid, IPC/service, TCP.
>
>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 ?
 

      A server type of NONE identifies a session that isn't currently doning anything. This seems to be what you'll see 99% of the time with Forms4.5 and Reports2.5. SqlPlus normally shows a value of SHARED. Refer to chapter 4 pg 15 of the Server Admin Guide. It talks about the KILLED and PSEUDO values.

>
>And also:
>
>Should MTS_SERVICE be set to sid or service name ?

    Set it to the sid.

>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.

      No idea about this one.

>
>hlu_at_datametrics.com
>
Received on Fri Jun 23 1995 - 00:00:00 CEST