SQL*Plus: SET ROWPREFETCH

set pages        5000
set arraysize       3
set rowprefetch     7
 
with
   function onesec(n number) return varchar is
      roundtrips number;
   begin
      select
         mys.value into roundtrips
      From
         v$mystat   mys   join
         v$statname nam on mys.statistic# = nam.statistic#
      Where
         nam.name = 'SQL*Net roundtrips to/from client';
 
      dbms_session.sleep(1);
      return to_char(n, '99') || to_char(roundtrips, '999');
   end onesec;
select
   onesec(level) x
from
   dual connect by level <= 40
/

$ sqlplus rene/rene@ora19 @arraysize-prefetch.sql