DBA Data[Home] [Help]

VIEW: SYS.CDB_CPOOL_INFO

Source

View Text - Preformatted

SELECT "CONNECTION_POOL","STATUS","MINSIZE","MAXSIZE","INCRSIZE","SESSION_CACHED_CURSORS","INACTIVITY_TIMEOUT","MAX_THINK_TIME","MAX_USE_SESSION","MAX_LIFETIME_SESSION","NUM_CBROK","MAXCONN_CBROK","CON_ID" FROM CONTAINERS("SYS"."DBA_CPOOL_INFO")
View Text - HTML Formatted

SELECT "CONNECTION_POOL"
, "STATUS"
, "MINSIZE"
, "MAXSIZE"
, "INCRSIZE"
, "SESSION_CACHED_CURSORS"
, "INACTIVITY_TIMEOUT"
, "MAX_THINK_TIME"
, "MAX_USE_SESSION"
, "MAX_LIFETIME_SESSION"
, "NUM_CBROK"
, "MAXCONN_CBROK"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_CPOOL_INFO")