-- Database configuration EXEC DBMS_CONNECTION_POOL.CONFIGURE_POOL('SYS_DEFAULT_CONNECTION_POOL', MINSIZE=10, MAXSIZE=100); EXEC DBMS_CONNECTION_POOL.START_POOL(); -- Client connection string sqlplus user/pass@//host:1521/prodservice:POOLED
[3] Oracle Linux Team. (2024). Oracle Instant Client Installation Guide for Linux x86-64 . Oracle Help Center. linux oracle client
PRODDB = (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = primary-host)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = standby-host)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = prodservice) (RETRY_COUNT = 3) (RETRY_DELAY = 5) ) ) For performance troubleshooting: -- Database configuration EXEC DBMS_CONNECTION_POOL