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:
Using DRCP (Database Resident Connection Pool) on client side: linux oracle client
[1] Oracle Corporation. (2023). Oracle Database Net Services Administrator's Guide , 21c Edition. Redwood City, CA. PRODDB = (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE =