How to configure Shared server mode

Shared memory resources are preconfigured to allow the enabling of shared server at run time. You need not configure it by specifying parameters in your initialization parameter file, but you can do so if that better suits your environment.

Steps are
Below are the init parameters needs to change ?
1- alter system set shared_servers=5;

 SQL>alter system set max_dispatchers=10 scope=spfile;;
 SQL>alter system set shared_server_sessions=5 scope=spfile;;
 SQL>alter system set circuits=300 scope=spfile;;
SQL>alter system set dispatchers="(protocol=TCP)(dispatchers=3)(connections=100)" scope=spfile;

client tnsfile should be like

Bounce the Database
To confirm shared server connection use below SQL query

SELECT name, status, messages,idle,busy,bytes,breakes from v$dispatcher;
select username,server from v$session;

———-to check shared server are idle or bussy query using——-

select name, dispatchers, substr(service,1,20) service, idle, busy
from v$dispatcher,v$dispatcher_config
where v$dispatcher.conf_indx = 
v$dispatcher_config.conf_indx ;



About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email:
This entry was posted in Database administration. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s