Discussion :

[sali]

salut
Je voudrais savoir a quoi sert les variables ARRAYSIZE et MAXDATA de SQLPULS
merci d'avance

[LeoAnderson]

http://download-east.oracle.com/docs...htm#sthref1561

SET ARRAYSIZE

Sets the number of rows that SQL*Plus will fetch from the database at one time. Valid values are 1 to 5000.

The effectiveness of setting ARRAYSIZE depends on how well Oracle Database fills network packets and your network latency and throughput. In recent versions of SQL*Plus and Oracle Database, ARRAYSIZE may have little effect. Overlarge sizes can easily take more SQL*Plus memory which may decrease overall performance.

Comme vous le voyez la doc. est très utile... je vous laisse le soin de la consulter pour la variable MAXDATA ! ;-)