Search notes:

SQL*Plus: SET ARRAYSIZE

The value of arraysize specifies the number or records that SQL*Plus fetches from the database in select statements.

The maximum value for arraysize is 5000.

See also

The default value of arraysize is changed to 100 when using SQL*Plus's command line option -fast.

SQL*Plus' set commands such as set rowprefetch

The value of arraysize also specifies the batch size for the copy command.

The stat name SQL*Net roundtrips to/from client.