Skip to main content

Smart database connection pooling with new jbo.ampool.connection_threshold parameter

Updated this post on 21-June-2013 to avoid further confusion on this topic

If you have seen application module configuration parameter editor in JDeveloper 11.1.1.7.0 release, you might have noticed a new property jbo.ampool.connection_threshold. Wondering what is it?




Well, this in an 'internal' property(NOT for public use at this moment) which has been introduced to avoid the overhead associated with normal connection pooling. In normal case when connection pooling is ON, framework will close all opened cursors at the end of a request and then will restore the state during next request. This creates some sort of overhead especially when you have partially fetched result set( for example data fetch caused by UI like scrollable table). The new parameter provides a way for users to strike an ideal balance by releasing JDBC connections only when a certain threshold is reached. This property defines maximum number of JDBC connections that all AM instances can hold without releasing them to pool on AM check-in. Once the connection threshold value is reached least recently used connections are released back to the pool during next clean up cycle.
-----------------------------------------------------------------------------------------------------------
Warning : This property is an undocumented feature and there is no guarantee that it will work across all servers and platforms. This is Not for public use at this moment. This blog post is just meant for clarifying the following question that you may have when you see it in the editor: 'What this new property is?'
-----------------------------------------------------------------------------------------------------------

Comments

Alumbrador said…
Hi Jobinesh,

Thanks for the post,

I have 2 questions:

Where Can I set this parameter?

What is the recommended value?

Jhon

Popular posts from this blog

Happy New Year 2018 !

We can't go back and change the beginning, but we always can start where we are and change the ending. Believe in yourself and you will be unstoppable!

Wishing you and your family a very happy new year 2018 !!!

How to set Bind Variable Values at runtime ?

In this post I'm sharing a couple of approaches for programmatically setting bind variables values at run time. This post is an attempt to explain 'When to use what ?'[ In case if you are familiar with 'Bind Variables' in ADF BC, please refer Section 5.10, Working with Bind Variables in Fusion Developer's Guide ]

1. Set the Bind Variable value using RowSet::setNamedWhereClauseParam(...)

You can use use the setNamedWhereClauseParam(...) method on the ViewObject interface (which extends oracle.jbo.RowSet) to set the value for bind variables. Please note this sets the value on default RowSet. In other words, this doesn't have any effect on the secondary RowSets that you/system generates.
ViewObject vo = am.findViewObject("EmployeesView1"); vo.setNamedWhereClauseParam("bindVarDeptId", new Number(10)); vo.executeQuery();
2. Set the Bind Variable value using ViewObject's VariableValueManager::setVariableValue(...)

VariableValueManager Ma…