20.10.2 Setting connection parameters

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.

LispWorks User Guide - 11 Mar 2008