-
Is there somebody who can provide me demo file for configuring the server in multi thread cause each time i try i failed
thanks
-
Have a look @ my posting
[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>
Reddy,Sam
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|