本代码参考 网络，整合后 语句，仅用于测试. 初始化5个连接，没关闭，观察orale监听日志及会话、进程相关信息
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
import oracle.jdbc.pool.OracleDataSource;
import oracle.jdbc.pool.OracleConnectionCacheManager;
public class ODBconn {
public static void main(String[] args) {
java.util.Properties prop = new java.util.Properties();
prop.setProperty("ConnectionWaitTimeout", "1");
prop.setProperty("InactivityTimeout", "20");
prop.setProperty("MaxStatementsLimit", "90");
prop.setProperty("MinLimit", "5");
prop.setProperty("MaxLimit", "10");
prop.setProperty("InitialLimit", "5");
// prop.setProperty("PropertyCheckInterval", "30");
try{
OracleDataSource ods = new OracleDataSource();
ods.setDriverType ( "thin" ); // type of driver
ods.setNetworkProtocol("tcp"); // tcp is the default anyway
ods.setServerName ( "192.168.80.116" ); // database server name
ods.setDatabaseName("mydb"); // Oracle SID
ods.setPortNumber(1521); // listener port number
ods.setUser("mytest"); // username
ods.setPassword("oracle"); // password
ods.setConnectionCachingEnabled(true);
ods.setConnectionCacheProperties(prop);
// ods.setConnectionCacheName("OralceConnectionCache");
// OracleConnectionCacheManager cacheManager = OracleConnectionCacheManager.getConnectionCacheManagerInstance();
Connection conn=ods.getConnection();
PreparedStatement ps=conn.prepareStatement("select count(*)from v$session where username='MYTEST'");
ResultSet rs=ps.executeQuery();
while (rs.next())
{
String source = rs.getString(1);
System.out.println(source);
}
System.in.read();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}
}