aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Statement cache sizing formula using Oracle driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Statement cache sizing formula using Oracle driver" Watch "Statement cache sizing formula using Oracle driver" New topic
Author

Statement cache sizing formula using Oracle driver

Vic Newman
Ranch Hand

Joined: Mar 01, 2002
Posts: 33
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Statement cache sizing formula using Oracle driver