[Home] [Help] [Dependency Information]
Object Name: | V_$CPOOL_STATS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POOL_NAME | VARCHAR2 | (1024) | ||
NUM_OPEN_SERVERS | NUMBER | |||
NUM_BUSY_SERVERS | NUMBER | |||
NUM_AUTH_SERVERS | NUMBER | |||
NUM_REQUESTS | NUMBER | |||
NUM_HITS | NUMBER | |||
NUM_MISSES | NUMBER | |||
NUM_WAITS | NUMBER | |||
WAIT_TIME | NUMBER | |||
CLIENT_REQ_TIMEOUTS | NUMBER | |||
NUM_AUTHENTICATIONS | NUMBER | |||
NUM_PURGED | NUMBER | |||
HISTORIC_MAX | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT POOL_NAME
, NUM_OPEN_SERVERS
, NUM_BUSY_SERVERS
, NUM_AUTH_SERVERS
, NUM_REQUESTS
, NUM_HITS
, NUM_MISSES
, NUM_WAITS
, WAIT_TIME
, CLIENT_REQ_TIMEOUTS
, NUM_AUTHENTICATIONS
, NUM_PURGED
, HISTORIC_MAX
, CON_ID
FROM SYS.V_$CPOOL_STATS;
|
|
|