ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
dbms_connection_pool.configure_pool(
pool_name IN VARCHAR2 DEFAULT SYS_DEFAULT_CONNECTION_POOL,
minsize IN BINARY_INTEGER DEFAULT 4,
maxsize IN BINARY_INTEGER DEFAULT 40,
incrsize IN BINARY_INTEGER DEFAULT 2,
session_cached_cursors IN BINARY_INTEGER DEFAULT 20,
inactivity_timeout IN BINARY_INTEGER DEFAULT 300,
max_think_time IN BINARY_INTEGER DEFAULT 120,
max_use_session IN BINARY_INTEGER DEFAULT 500000,
max_lifetime_session IN BINARY_INTEGER DEFAULT 86400
max_txn_think_time IN BINARY_INTEGER);
conn sys@pdbdev as sysdba
set linesize 121
col connection_pool format a30
SELECT connection_pool, maxsize
FROM dba_cpool_info;