Thursday, June 20, 2013

JDev/ADF sample - ADF BC 11g PS6 DB Pooling Threshold (New) Property Problem

  • ADF BC 11g PS6 DB Pooling Threshold (New) Property Problem. During OOW'12, it was announced by ADF BC team - new tuning property for ADF BC with DB pooling enabled, coming in the next releases - jbo.ampool.connection_threshold. The main idea is to keep connected JDBC connections until predefined threshold limit is reached, once limit is reached - ADF BC will be returning least used JDBC connections back to the pool. This would allow to keep less open JDBC connections and at the same time for active AM's it will not disconnect JDBC connection on each request. Currently with DB pooling enabled, JDBC connection is disconnected and returned back to the pool after each request (still it works quite well) - Stress Testing Oracle ADF BC Applications - Do Connection Pooling and TXN Disconnect Level.
    Download - DBConnectionThresholdApp.zip

No comments: