DBA Data[Home] [Help]

VIEW: SYS.INT$DBA_CPOOL_INFO

Source

View Text - Preformatted

SELECT
  connection_pool_name,
  status,
  minsize,
  maxsize,
  incrsize,
  session_cached_cursors,
  inactivity_timeout,
  max_think_time,
  max_use_session,
  max_lifetime_session,
  num_cbrok,
  maxconn_cbrok
FROM cpool$
View Text - HTML Formatted

SELECT CONNECTION_POOL_NAME
, STATUS
, MINSIZE
, MAXSIZE
, INCRSIZE
, SESSION_CACHED_CURSORS
, INACTIVITY_TIMEOUT
, MAX_THINK_TIME
, MAX_USE_SESSION
, MAX_LIFETIME_SESSION
, NUM_CBROK
, MAXCONN_CBROK FROM CPOOL$