There are improved default prefetch values for Oracle database connections, and control over the amount to prefetch. See "Setting connection parameters" in the LispWorks User Guide .