|
|
|
|
| Re: EDITING MAXIMUM CONNECTION [message #121359 is a reply to message #120953] |
Fri, 27 May 2005 14:45  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
Please check out below written things.....
MTS (Multithreaded Server or shared server)
Oracle server allows a large number of connections without increasing the resources of the database.
CHANGES IN ORACLE SERVER DUE TO MTS CONFG
Oracle adds 2 (two) new types of structures in the SGA
[1] Request queue -> For all dispatcher.
[2] Response queue. -> Individual for each dispatcher.
Shared server process executes each request and then gives it to the dispatcher.
Need to configure DESPATCHERS and SHARED SERVER processes.
User session data is stored in Large Pool in MTS.
---------------------------------------------------------------
CONFIGURE MTS
===============
In Init.ora Parameters.
DISPATCHERS=’(PRO=TCP) (DIS=5)’
MAX_DISPATCHERS = 20
SHARED_SERVERS = 10
-----
PRO-> Represent which protocol is used
DIS-> Number of dispatcher.
SHARED_SERVER-> Interface between Dispatcher & Oracle DB
Now shut down
SQL>SHUTDOWN
SQL>STARTUP
If we want to add more dispatcher than
SQL>ALTER SYSTEM SET DISPATHERS=’(PRO=TCP) (DIS=10)’;
To increase number of SHARED_SERVER
SQL>ALTER SYSTEM SET SHARED_SERVER = 20;
SQL>DES V$SESSION
SQL>SELECT USERNAME, SERVER, TERMINAL FROM V$SESSION;
--->If value of column is NONE than it is shared server or it will have DEDICATED as value
-->When our connection is going to be dedicated or shared is decided by how you connects to database. When we give connection string locally to connect it is treated as remote so it shows NONE.
I hope this should clear your concept for changing database mode form dedicated to MTS and will solve your problem too.
From:- Sunilkumar Vishwanath Mishra.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
