Hi,
I'm working on an Oracle Database 11g Release 11.1.0.6.0 - 64bit Production With the Real Application Clusters option.
I'm try to understand better the behavior of the DRCP I set up for my web application.
The connection pool has this configuration (from dba_cpool_info):
CONNECTION_POOL SYS_DEFAULT_CONNECTION_POOL
STATUS ACTIVE
MINSIZE 4
MAXSIZE 100
INCRSIZE 2
SESSION_CACHED_CURSORS 20
INACTIVITY_TIMEOUT 300
MAX_THINK_TIME 120
MAX_USE_SESSION 500000
MAX_LIFETIME_SESSION 86400
and this actual value (from v$cpool_stats):
POOL_NAME SYS_DEFAULT_CONNECTION_POOL
NUM_OPEN_SERVERS 37
NUM_BUSY_SERVERS 30
NUM_AUTH_SERVERS 1
NUM_REQUESTS 93156
NUM_HITS 0
NUM_MISSES 93156
NUM_WAITS 0
WAIT_TIME 0
CLIENT_REQ_TIMEOUTS 0
NUM_AUTHENTICATIONS 2571
NUM_PURGED 0
HISTORIC_MAX 37
What suddenly I noticed is that num_misses = num_request.
As I understood a MISSES is a request for which has not been found an available connection in the pool, and for which a new has to be created.
Is that true?
If yes, what's wrong that cause this behaviour?
Thanks in advance,
Samuel