Setting connection parameters for Oracle

Hello,

When fetching large result sets, it seems that Lispworks operates with
a buffer size of 1 thus causing one round trip for every row fetched.
This takes a lot of time; for instance 40k rows takes about 48 seconds
in Lispworks while sqlplus uses 6 seconds with ARRAYSIZE set to 1000.

I have been unable to find any way of setting the buffer size using the
Lispworks Oracle driver.  Does anyone on this list know how its done?

  * Lispworks 5.0.1 Enterprise IA32 on AM64.
  * Oracle client 8.0.5.
  * Oracle server 8.1.7.0.1 and 10.1.0.4.0 tested.


Thanks in advance,
                    Bjørn