Re: What exactly is arraysize/maxdata

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 19 May 1999 00:23:13 +0200
Message-ID: <927066076.13789.0.pluto.d4ee154e@news.demon.nl>

Hi Doug,
Maxdata in sql*plus is the number of bytes than can be fetched in one operation. You could guess this limit is 64k. Oracle supports array fetching, multiple rows can be fetched in one operation. The total size of those rows should not exceed 64k. The standard array size in sql*plus is 12, IMHO. By issuing set array something lower you can get rid of this problem.

Hth,

Sybrand Bakker, Oracle DBA

Doug Cowles wrote in message <3741D2BA.2872F9A3_at_bigfoot.com>...
>Whenever I query the user_trigger table, it requests that I reduce
>arraysize or increase maxdata. Can anyone provide more detail on what
>these are?
>
>- Dc.
>
Received on Tue May 18 1999 - 17:23:13 CDT