This week's book giveaway is in the Features new in Java 9 forum.
We're giving away four copies of Java 9 Revealed and have Kishori Sharan on-line!
See this thread for details.
Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle10g implicit caching with jdbc - cache only grows?  RSS feed

 
Yuriy Zilbergleyt
Ranch Hand
Posts: 429
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Does the implicit cache of Oracle's 10g drivers (using ojdbc14.jar) ever release unused connections? For example, we set the MinLimit property in the OracleDataSource to 15 and the MaxLimit to 40. Already opened connections get reused as expected, and when they're not enough new ones are opened. However, once the load on the application dies down, the number of connections never decreases back down to the MinLimit. If 40 connections are opened, all 40 remain until the application shuts down. Are we supposed to call the OracleConnectionCacheManager.purgeCache() method to free up unused connections at regular intervals? That doesn't seem right....

Thank you,
Yuriy
[ June 25, 2007: Message edited by: Yuriy Zilbergleyt ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!