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.