Re: Performance Tuning

From: Chrysalis <cellis_at_iol.ie>
Date: 1997/04/28
Message-ID: <3364D2A1.1320@iol.ie>#1/1

If this is now true, it is totally new to me. AFIK, arraysize affects only rows retrieved in a SQL statement issued from SQL*Plus.
PL/SQL always fetches rows one at a time, at least up to V7.2.

Chrysalis.

mjc wrote:
>
> If you want to fetch a batch of rows into a PL/SQL cursor, add the
> following statement at the start of your PL/SQL code - after the initial
> 'BEGIN' statement (It is a SQL*Plus command)
>
> SET ARRAYSIZE 100
>
>
> snip
>
> Stevan R. Makarevich <smakar_at_primenet.com> wrote in article
> <3362d05f.1446145_at_news.primenet.com>...
> snip
Received on Mon Apr 28 1997 - 00:00:00 CDT