Multi thread server

[alainc]

Is there somebody who can provide me demo file for configuring the server in multi thread cause each time i try i failed

thanks

[sreddy]

[url]http://www.dbasupport.com/forums/showthread.php?threadid=6654[/url]

Pretty much thats it and bounce the database and login to sqlplus and run the query it should show up your userid under MTS as SHARED. If not troubleshoot.

SQL> select username,server from v$session ;
DBSNMP DEDICATED
ADMIN NONE
ADMIN NONE
ADMIN NONE
SREDDY SHARED
SQL>

[rohitsn]

Hi,
Please write to me at rohitsn@altavista.com I will send u a sample init.ora file which will give u all the parameters to configure ur system for MTS

#Configuring your server to be multithreaded server

#local_listener=bscs521 #service name with which
dispatcher gets registered
#mts_service=bscs #instance name
#mts_dispatchers="(protocol=tcp)(poo=yes)(dispatchers=1)" #initial no of dispatchers started
for tcp/ip
#mts_max_dispatchers=2 #max no of dispatchers
#mts_servers=1 #initial no of shared servers
started
#mts_max_servers=3 #max no of shared servers


Regards,
Rohit Nirkhe,oracle DBA,OCP