Multi thread server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Multi thread server

  1. #1
    Join Date
    Jan 2001
    Posts
    44

    Question

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

    thanks

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    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

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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
  •  


Click Here to Expand Forum to Full Width