Linux Oracle Client
-- Database configuration EXEC DBMS_CONNECTION_POOL.CONFIGURE_POOL('SYS_DEFAULT_CONNECTION_POOL', MINSIZE=10, MAXSIZE=100); EXEC DBMS_CONNECTION_POOL.START_POOL();
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) ) ) linux oracle client
Test the Oracle Client connection using the sqlplus command: -- Database configuration EXEC DBMS_CONNECTION_POOL
trcasst /var/log/oracle/cli_*.trc
For performance troubleshooting: