Hi Tom,

Configuration:-
---------------------
1) Oracle weblogic app server is used
2) The connection pool in side weblogic is set as MIN=1200 INITIAL=1200 MAX=1200
3) 8 managed + 1 admin servers inside weblogic
4) so total number sessions established with the database server is [1200 * 9 = 10800 ]
5) The RAM available inside database server is 128 GB
6) SGA=32GB, PGA=16GB AMM is in place and not ASMM
7) Number of CPU is 32

Observation:-
----------------
1) When all the app server is shut down, there are no connections
the os command out put is as below

free -g
total used free shared buffers cached
Mem: 125 26 99 0 0 13
-/+ buffers/cache: 13 112
Swap: 23 9 14

2) When all the app server is up, and there are 108000 sessions established

free -g
total used free shared buffers cached
Mem: 125 110 15 0 0 14
-/+ buffers/cache: 95 30
Swap: 25 0 25

3) As the load increases the number of sessions are increasing beyond 108000 and the free RAM is getting reduced further
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
------------------------------ ------------------- --------------- ---------- ----------
processes 10852 10871 20000 20000
sessions 10865 12454 30048 30048

4) But when there are no workload sessions are not aging out and the free memory is not increasing, the memory is not getting freed up.

5) Is this behavior is The Design ? then each session is nearly consuming 8MB of RAM outside of SGA+PGA, is this OK ?

6) If it is ok, then I have only one option instead of sting high values in the connection pool have to reduce to some lower and optimal value.

Thanks and Regards,
Sandeep