Oracle database connections have prefetch values which you can control via Common SQL. Alternatively you can allow the database default prefetch values to take effect.
You can set the default prefetch values for a connection by passing
:prefetch-rows-number
and
:prefetch-memory
keyword arguments to
connect
. The default value of
prefetch-rows-number
is 100 and the default value of
prefetch-memory
is #x100000 (meaning 1MB of data).
You can also pass the value
:default
for either of these arguments. This means that Common SQL does not set the default. This is useful if Oracle itself provides a suitable default.