Expert Oracle JDBC Programming

C H A P T E R  13

Statement Caching

Statement caching is a JDBC 3.0 feature designed to improve performance by caching statements that are used repeatedly (e.g., in a loop) in the same session. By caching the statements, you prevent the overhead of repeated parsing of the cursor.

In this chapter, you'll learn about statement caching, its different flavors in JDBC, and how it improves the performance of JDBC programs. As a background to the statement caching concept, you'll first go through a detailed discussion of cursors and ref cursors. You'll also learn about two other related caches, namely the PL/SQL cursor cache (which is the equivalent ...