• Post Reply Bookmark Topic Watch Topic
  • New Topic

Statement cache sizing formula using Oracle driver

 
Vic Newman
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When using the Oracle jdbc thin driver and you want to implement statement caching what formula do you use in determining the size of the cache? How does it relate to the number of connections allocated for your connection pool. Also, are ther any Oracle system settings you must pay close attention to when enabling statement caching? Fr example max_cursors?

Thanks,
Vic
 
If you are using a wood chipper, you are doing it wrong. Even on this tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!