3.7. Multi-Tier-specific Connection-Pooling

3.7.1. Multi-Tier-specific configuration

The required parameters are configured through environment-variables - either use the web-based Administrative Assistant (normally located at <http://server:8000/>) navigating through `Server Components Administration', `Database Agent Administration', `Database Agent Settings by Form', select the name of the agent section used, and scroll to the section `OpenLink Agent Startup Parameters', or edit the rulebook file (oplrqb.ini) directly, to assert settings for the OCI_CONNPOOL_* settings below:

[Environment ORACLE90]
ORACLE_HOME        = /dbs/oracle90
ORACLE_SID         = ORCL
;ORACLE_SERVER      = T
;TWO_TASK           = P:
;ODBC_CATALOGS      = Y         ; Uncomment after loading odbccat9.sql
;MULTIPLEX_LDA      = 5         ; Allow 5 OpenLink clients on a single lda
;OPL_USR_TBLS_FIRST = Y         ; Sort SQLTables starting with user tables
SHOW_REMARKS       = N  ; Retrieve SQLColumns REMARKS field
CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading odbccat9.sql
;OCI_PREFETCH_ROWS  = 100       ; Number of rows to prefetch
;OCI_PREFETCH_MEMORY = 65535    ; Amount of memory to use for prefetching
;LD_LIBRARY_PATH = /dbs/oracle81/lib    ; Find shared libraries
;SHLIB_PATH      = /dbs/oracle81/lib    ; Find HP/UX shared libraries
;LIBPATH         = /dbs/oracle81/lib    ; Find AIX shared libraries
;NLS_LANG        = AMERICAN_AMERICA.UTF8 ; Uncomment for Unicode connections
OCI_CONNPOOL_MIN = 0         ; minimum initial connections in pool
OCI_CONNPOOL_INCR = 1        ; number of new connections when others busy
OCI_CONNPOOL_MAX = 1         ; sum of MIN+INCR
OCI_CONPOOL_WAIT = TRUE      ; whether new query waits or errors when all busy
OCI_CONNPOOL_LINGER = 0      ; seconds to linger after last connection cleared

OCI connection pooling is disabled by setting a minimum connection pool size of 0.