WebLogic Server Datasource Gradual Draining by Steve Felts


In October 2014, we delivered Oracle WebLogic Server 12.2.1 as part of the overall Oracle Fusion Middleware 12.2.1 Release and October 2015 we delivered the first patch set release This week, the second patch set is available.   New WebLogic Server installers are now posted on the Oracle Technology Network and Oracle Software Delivery Cloud, and new documentation has been made available. There are a couple of new datasource features hidden there. One of them is called “gradual draining.”

When planned maintenance occurs on an Oracle RAC configuration, a planned down service event is processed by an Active GridLink data source using that database. By default, all unreserved connections in the pool are closed and borrowed connections are closed when returned to the pool.  This can cause an uneven performance because:

· New connections need to be created on the alternative instances.

· A logon storm on the other instances can occur.

It is desirable to gradually drain connections instead of closing them all immediately. The application can define the length of the draining period during which connections are closed. It is configured using the weblogic.jdbc.drainTimeout value in the connection properties for the datasource. As usual, it can be set in the console, EM, or WLST. The following figure shows the administration console.

The result is that connections are closed in a step-wise fashion every 5 seconds. If the application is actively using connections, then they will be created on the alternative instances at a similar rate. The following figure shows a perfect demonstration of draining and creating new connections over a 60 second period using a sample application that generates constant load.  Without gradual draining, the current capacity on the down instance would drop off immediately similar to the LBA percentages and connections would be created on the alternative instance as quickly as possible. Read the complete article here.

WebLogic Partner Community

For regular information become a member in the WebLogic Partner Community please visit: http://www.oracle.com/partners/goto/wls-emea ( OPN account required). If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Forum Wiki

Technorati Tags: WebLogic Community,Oracle,OPN,Jürgen Kress

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.