This discussion is archived
3 Replies Latest reply: Nov 26, 2012 2:27 AM by 746690 RSS

Datasource Maximum capacity in Cluster

877383 Newbie
Currently Being Moderated
Hi,

I have configured a datasource and assigned maximum capacity of 10 and initial capacity to 2 and targeted it to all server in a clusters(node 1 & node 2).
now how the connections will be utilized in the clustered mode. Both the node will have maximum of 10 connection limit
or each node will have maximum of 10 connection limit ? please clarify me.

Thanks
KK
  • 1. Re: Datasource Maximum capacity in Cluster
    770632 Explorer
    Currently Being Moderated
    Each node will have a maximum 10 connections. So if all connections get used, you should see 20 connections to the database. And to start with you should see 4 connections on teh database side

    Atul
  • 2. Re: Datasource Maximum capacity in Cluster
    Kalyan Pasupuleti-Oracle Expert
    Currently Being Moderated
    Hi KK,

    Here is the proper explanation when you assigned any services to cluster then one set of services instance will be created.

    I mean like if you have 2 node in cluster and one DS with 10 Max capacity size.

    If both the server are in the cluster environment then it share the resource equally.

    So when any instance started then temporary pool will be created for that particular server and created those many connection objects.


    10 Max pool size X 2 Server in cluster = 20 Connection objects.


    This is how cluster will increase the performance your environment compare single server.

    Still you have any further query let me know.

    Regards,
    Kal
  • 3. Re: Datasource Maximum capacity in Cluster
    746690 Explorer
    Currently Being Moderated
    Maximum Capacity

    Maximum capacity is number of allocated session in database side for WebLogic Server divide by number of WebLogic server. Example, DBA allocated 500 session for WebLogic server which has 5 server, so this config value is 500/5 = 100

    Initial Capacity

    Initial capacity mean number of initial session created when data source started. Recommended value for Initial Capacity is equal to Maximum Capacity size database connection pools. In this case WebLogic never increase the number of connections when it needed by application. Negative impact for this case is increase DB load although only few session use by WebLogic, but if impact in database side is not significant its work well.

    Regards
    Mukesh Negi
    http://weblogicserveradministration.blogspot.in/2010/10/jdbc-connection-pool-performance-tuning.html

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points