Friday, February 28, 2014

DBC file parameters for R12

DBC file parameters for R12 :

FND_MAX_JDBC_CONNECTIONS=200
FND_JDBC_BUFFER_MIN=5
FND_JDBC_BUFFER_MAX=25%
FND_JDBC_BUFFER_DECAY_INTERVAL=60
FND_JDBC_BUFFER_DECAY_SIZE=1
FND_JDBC_USABLE_CHECK=true
FND_JDBC_CONTEXT_CHECK=true
FND_JDBC_PLSQL_RESET=false

When Apache starts, it will create a buffer of 5 JDBC connections (FND_JDBC_BUFFER_MIN=5) plus a few more as Java dependent products initialize. As users login, those 5 connections will get used and more connections will be created to replenish the buffer. These connections will increase as needed up to the limit of 200 (FND_MAX_JDBC_CONNECTIONS). As users log off, the JDBC connections will die off at a rate of 1 every 60 seconds (FND_JDBC_BUFFER_DECAY_SIZE=1, FND_JDBC_BUFFER_DECAY_INTERVAL=60), but this decay won’t start until you have reached 50 JDBC connections (25% of 200 where FND_JDBC_BUFFER_MAX=25% and FND_MAX_JDBC_CONNECTIONS=200). The decay will slowly reduce the number of inactive JDBC connections down to FND_JDBC_BUFFER_MIN=5, with the least recently used ones being removed first. Note - that each of these parameters are per JVM.

No comments: