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

sales=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=sales.us.acme.com)
(SERVER=shared)))
Bounce the Database
To confirm shared server connection use below SQL query

SELECT name, status, messages,idle,busy,bytes,breakes from v$dispatcher;
and
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 and 11g OCE and OCS, Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g and 11g. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s