use-fetch-size-with-long-column
Last updated: February 3, 2026
oracle.jdbc.useFetchSizeWithLongColumn is a JVM system property that controls how the Oracle JDBC driver handles fetch sizes when querying tables containing LONG or LONG RAW columns. It is available in Liquibase 5.1.0 and later. The default value is true, which enables optimized batch fetching for improved performance on Oracle databases. You can set this property to false if you need more controlled memory usage when working with large LONG or LONG RAW data types.
Applicable Liquibase commands:
snapshot(most common use case)
Uses
You might want to set this property to false in scenarios where:
Memory constraints
- Your environment has limited memory resources and you need more controlled fetching to prevent the driver from eagerly loading large amounts of data
Large LONG/LONG RAW data
- You're working with very large LONG or LONG RAW data types and need to manage how data is fetched to avoid memory issues
Resource management
- Your application requires fine-grained control over memory usage when processing large-scale data
In these cases, disabling the optimization allows for more controlled, smaller-batch fetching rather than the default behavior of fetching data in larger chunks.
Syntax
You can set this parameter in the following ways:
Option | Syntax |
Global CLI parameter |
|
JVM system property (JAVA_OPTS environment variable) | Unix:
Windows:
|