Comparing jdbc-thin versus jdbc-oci

TEST ENVIRONMENT

An OEL Dropbox VM macchine running on Intel i5 laptop 8Gb RAM 250 Gb SAS disk

The VM is the “Oracle Big Data Lite Virtual Machine 12c” located here http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-2104726.html#download_bdalite

The VM is configured with 6810MB and 3 vcpus

TEST ARTIFACTS

Here the link to the java project utilized for the test

Here a shell script sample

Here test data sample

Here sql DDL/DML data sample

TEST EXPLANATION

The test repeats a connection/select-fetch/disconnect pattern the specified number of tries.

The test has been run with different table row sizes, ant he response patter is always simillar.

TEST RESULTS

The following chart shows the response times, jdbc-oci takes near 20% more time in average.

Please note that this results can’t be extrapolated to results obtained in native OCI implementations.

DISCLAIMER

This results are only for demonstration purposes and haven’t been verified.

The test equipment haven’t been optimized nor tuned.