Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Behaviour of statement cache for Oracle Database in UCP

tapjOct 24 2013 — edited Oct 15 2014

UCP documentation says that statement cache for oracle database can be enabled by setting below:

pds.setMaxStatements(10)

How do we get performance enhancements here. As when we create a connection we do not provide statement. May be some other connection in the pool have the statement cached (which we will prepare later). lets say pds is a PoolDataSource

Connection conn = pds.getConnection();

This connection object returned from the pool may or may not have statement cached. So how do we achieve performance enhancements by enabling statement cache.

This post has been answered by unknown-7404 on Oct 24 2013
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 22 2013
Added on Oct 24 2013
7 comments
1,297 views