Attributes of a Multi Data Source

The multi data source may have the following attributes, depending on the role of Oracle RAC in your system—load balancing or failover:

• AlgorithmType="Load-Balancing" or AlgorithmType="Failover"

  With the Load-Balancing option, connection requests are distributed among available data sources; with the High-Availability option, connection requests are served by the first available pool in the list. When a data source becomes defunct, connection requests are served by the next data source in the list.

• FailoverRequestIfBusy="true"

  With the Failover algorithm, this attribute enables failover when all connections in a data source are in use.

• TestFrequencySeconds="120"

  This attribute controls the frequency at which WebLogic Server checks the health of data sources previously marked as unhealthy to see if connections can be recreated and if the data source can be re-enabled. For more details see Chapter 5, "Configuring JDBC Multi Data Sources."

  For fast failover of Oracle RAC nodes, set this value to a smaller interval, for example, 10 (seconds).