[weblogic] 데이터소스에서 DRCP 사용하기

#. 참고 글

https://docs.oracle.com/middleware/1221/wls/JDBCA/ds_oracledriver.htm#JDBCA622

https://docs.oracle.com/en/database/oracle/oracle-database/19/jjdbc/database-resident-connection-pooling.html#GUID-D4F9DBD7-7DC6-4233-B831-933809173E39

https://stackoverflow.com/questions/30324511/enable-drcp-in-weblogic-12c-fails

https://blog.naver.com/hiizero/220558651287

 

---

 

oracle.jdbc.DRCPConnectionClass

해당 값은 DB 서버 어딘가에 있는 설정 값을 찾아서 입력하는 것이 아니라

임의의 값을 지정하여 입력하는 것이다.

 

여러 데이터소스들이 동일한 oracle.jdbc.DRCPConnectionClass 값으로 통일되어 있으면

모든 데이터소스들이 동일한 DRCP 풀을 공유하게 되는 구조인 듯 하다.

 

 

테스트에 사용한 명령어 (추후 정리 필요함)

https://blog.naver.com/hiizero/220558651287
https://stackoverflow.com/questions/30324511/enable-drcp-in-weblogic-12c-fails

SQL> connect / as sysdba
SQL> execute dbms_connection_pool.configure_pool(null, minsize=>30, maxsize=>30, inactivity_timeout=>300, max_think_time=>600);
SQL> execute dbms_connection_pool.start_pool;
SQL> select * from DBA_CPOOL_INFO;

SQL> select * from DBA_CPOOL_INFO;
SQL> select * from V$CPOOL_STATS;
SQL> select * from V$CPOOL_CC_INFO;
SQL> select * from V$CPOOL_CC_STATS;

select * from v$resource_limit where resource_name = 'processes';
alter system set processes=2000 scope=spfile;
ALTER SYSTEM SET OPEN_CURSORS=2000;
commit;

execute DBMS_CONNECTION_POOL.CONFIGURE_POOL('SYS_DEFAULT_CONNECTION_POOL');

execute DBMS_CONNECTION_POOL.CONFIGURE_POOL (session_cached_cursors=>50);

jdbc:oracle:thin:@//192.168.55.169:1521/orcl


execute dbms_connection_pool.start_pool();



execute dbms_connection_pool.stop_pool();

oracle.jdbc.pool.OracleDataSource