23.10.1 Connection specification

See Connecting to Oracle for information about Oracle-specific interpretation of the connection-spec passed to connect.

23.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 1 MB 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.