Dedicated Vs Shared Server in JDBC
chakraFeb 17 2010 — edited Feb 17 2010We are using a client application which generates nearly 300 connections using connection pool. The connections are 'dedicated one'. See the connection description below.
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@(description=(address=(host= myhost)(protocol=tcp)(port=1521))
(connect_data=(SERVICE_NAME=orcl)(SERVER = DEDICATED)))", "scott", "tiger");
We are planning to change the SERVER = SHARED to move into the shared server mode. We would like to know, how shared server connection can be made on a database 10.1.0.5 and what are the parameters needs to be changed? Any reference would be useful.
Regards, Anirban