• 標簽：共享服務器進程、shared server process
• 釋義：shared server process是Oracle的一種數據庫連接技術，類似的還有專用模式和DRCP

---

★ 數據庫配置

alter system set shared_server_sessions=1 scope=spfile;
alter system set max_shared_servers=1 scope=spfile;
alter system set shared_servers=1 scope=spfile;
alter system set max_dispatchers=1 scope=spfile;
alter system set dispatchers='(PROTOCOL=TCP)(DISPATCHERS=1)' scope=spfile;

★ Java代碼

package PAC_001;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;
import oracle.jdbc.pool.OracleDataSource;
public class CLA_oracle {public static void main(String args[]) throws SQLException {OracleDataSource ods = null;Connection conn = null;Statement stmt = null;ResultSet rset = null;ods = new OracleDataSource();ods.setURL("jdbc:oracle:thin:@1.1.1.9:1521/prodpdb1:shared");ods.setUser("zzt");ods.setPassword("zzt");conn = ods.getConnection();try {stmt = conn.createStatement();rset = stmt.executeQuery("SELECT count(*) FROM zzt.emp");while (rset.next())System.out.println(rset.getString(1));}finally {if (rset != null)rset.close();if (stmt != null)stmt.close();if (conn != null)conn.close();}}
}

---

※ 如果您覺得文章寫的還不錯，?別忘了在文末給作者點個贊哦 ~