[Home] [Help] [Dependency Information]
Object Name: | CPOOL$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CPOOL$_UI | NORMAL | UNIQUE | SYSTEM | CONNECTION_POOL_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONNECTION_POOL_NAME | VARCHAR2 | (128) | ||
STATUS | VARCHAR2 | (16) | ||
MINSIZE | NUMBER | |||
MAXSIZE | NUMBER | |||
INCRSIZE | NUMBER | |||
SESSION_CACHED_CURSORS | NUMBER | |||
INACTIVITY_TIMEOUT | NUMBER | |||
MAX_THINK_TIME | NUMBER | |||
MAX_USE_SESSION | NUMBER | |||
MAX_LIFETIME_SESSION | NUMBER | |||
NUM_CBROK | NUMBER | |||
MAXCONN_CBROK | NUMBER |
Cut, paste (and edit) the following text to query this object:
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 SYS.CPOOL$;
SYS.CPOOL$ does not reference any database object
SYS.CPOOL$ is referenced by following:
|
|
|