3 Replies Latest reply: Oct 15, 2013 5:39 AM by Kovachev RSS

    DRCP: num_misses = num_reqeust

    Samuel Rabini
      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