DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_CPOOL_INFO

Object Details
Object Name: CDB_CPOOL_INFO
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Connection pool info in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONNECTION_POOL VARCHAR2 (128)
Connection pool name
STATUS VARCHAR2 (16)
connection pool status
MINSIZE NUMBER

Minimum number of connections
MAXSIZE NUMBER

Maximum number of connections
INCRSIZE NUMBER

Increment number of connections
SESSION_CACHED_CURSORS NUMBER

Session cached cursors
INACTIVITY_TIMEOUT NUMBER

Timeout for an idle session
MAX_THINK_TIME NUMBER

Max time for client to start activity on an acquired session
MAX_USE_SESSION NUMBER

Maximum life of a session based on usage
MAX_LIFETIME_SESSION NUMBER

Maximum life of a session based on time
NUM_CBROK NUMBER

MAXCONN_CBROK NUMBER

CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


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 SYS.CDB_CPOOL_INFO;

Dependencies

[top of page]

SYS.CDB_CPOOL_INFO does not reference any database object

SYS.CDB_CPOOL_INFO is referenced by following:

SchemaPUBLIC
SynonymCDB_CPOOL_INFO