We have a very nice Java-Application at our side, and wanted to speed up the performance with the OracleDataSource (before we were working with Standard JDBC).

oracle.jdbc.pool.OracleDataSourceSo we tested a lot and the performance was slightly better in the test-environment than before.After that we went to production with it.... and the phones began to rang, the performance was BAD BAD BAD Cry

After 3 hours of analyzing of our sourcecode we had the solution:

                        Caching is not enabled by default  (suprise surprise... by Oracle)

After adding  additionals lines

        <jdbc-connection-pool datasource-classname= "oracle.jdbc.pool.OracleDataSource" ...>
        <property name="ImplicitCachingEnabled" value="true"/>
        <property name="MaxStatements" value="190"/>
        </jdbc-connection-pool>

We had an incredible speed up! 

The application is now about 10 times faster than before using this DataSource.  If it is possible in any case use this Datasource!