salut
Je voudrais savoir a quoi sert les variables ARRAYSIZE et MAXDATA de SQLPULS
merci d'avance
Version imprimable
salut
Je voudrais savoir a quoi sert les variables ARRAYSIZE et MAXDATA de SQLPULS
merci d'avance
http://download-east.oracle.com/docs...htm#sthref1561
Comme vous le voyez la doc. est très utile... je vous laisse le soin de la consulter pour la variable MAXDATA ! ;-)Citation:
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.