t_row(i).field1 
t_row(i).field2
t_row(i).field3 

  
r_row := t_row(i)
r_row.field1 
r_row.field2
r_row.field3 

mem=1,97          -- До инициализации коллекции
mem=2070,66    -- После инициализации коллекции 

mem1=2070,66
+000000000 00:00:04.384097000   -- вариант  без копирования

mem2=2070,66
+000000000 00:00:04.659616000   -- вариант с копированием

DECLARE
   TYPE typ_rec IS RECORD(
     n1  NUMBER,n2  NUMBER,n3  NUMBER,n4  NUMBER,n5  NUMBER,n6  NUMBER,n7  NUMBER,n8  NUMBER,n9  NUMBER,
     s1  VARCHAR2(1000), s2  VARCHAR2(1000),s3  VARCHAR2(1000),s4  VARCHAR2(1000),s5  VARCHAR2(1000),s6  VARCHAR2(1000),
     d1  DATE, d2  DATE,d3  DATE,d4  DATE, d5  DATE, d6  DATE, d7  DATE, d8  DATE
   );
   TYPE typ_tbl IS TABLE OF typ_rec INDEX BY PLS_INTEGER;
   t_row typ_tbl;
   r_row typ_rec;
   tmp   VARCHAR2(4000);
   strt  TIMESTAMP; 
   
  FUNCTION get_mem RETURN NUMBER IS
    l_res NUMBER;
  BEGIN
    SELECT round(sum(ms.VALUE) / 1024 /1024,2) INTO l_res
    from v$statname sn, v$mystat ms
    where sn.name = 'session pga memory' and ms.STATISTIC# = sn.STATISTIC#
    order by sn.NAME;
    RETURN l_res;    
  END;  
   
BEGIN
   r_row.n1 := 1;
   r_row.n2 := 2;
   r_row.n3 := 3;
   r_row.n4 := 4;
   r_row.n5 := 5;
   r_row.n6 := 6;
   r_row.n7 := 7;
   r_row.n8 := 8;
   r_row.n9 := 9;
   r_row.s1 := 's1';
   r_row.s2 := 's2';
   r_row.s3 := 's3';
   r_row.s4 := 's4';
   r_row.s5 := 's5';
   r_row.s6 := 's6';
   r_row.d1 := SYSDATE;
   r_row.d2 := SYSDATE;
   r_row.d3 := SYSDATE;
   r_row.d4 := SYSDATE;
   r_row.d5 := SYSDATE;
   r_row.d6 := SYSDATE;
   r_row.d7 := SYSDATE;
   r_row.d8 := SYSDATE;
   
   dbms_output.put_line('mem='||get_mem); 
   FOR i IN 1..2000000 LOOP
     t_row(i) := r_row;
   END LOOP;  
   dbms_output.put_line('mem='||get_mem); 
   

   strt := SYSTIMESTAMP;
   FOR i IN 1..t_row.count LOOP
      tmp := t_row(i).n1||t_row(i).n2||t_row(i).n3||t_row(i).n4||t_row(i).n5||t_row(i).n6||t_row(i).n7||t_row(i).n8||t_row(i).n9
        ||t_row(i).s1||t_row(i).s2||t_row(i).s3||t_row(i).s4||t_row(i).s5||t_row(i).s6
        ||t_row(i).d1||t_row(i).d2||t_row(i).d3||t_row(i).d4||t_row(i).d5||t_row(i).d6||t_row(i).d7||t_row(i).d8;
   END LOOP;            
   dbms_output.put_line('mem1='||get_mem); 
   dbms_output.put_line(SYSTIMESTAMP - strt); 
   
     
   strt := SYSTIMESTAMP;
   FOR i IN 1..t_row.count LOOP
      r_row := t_row(i);
      tmp := r_row.n1||r_row.n2||r_row.n3||r_row.n4||r_row.n5||r_row.n6||r_row.n7||r_row.n8||r_row.n9
        ||r_row.s1||r_row.s2||r_row.s3||r_row.s4||r_row.s5||r_row.s6
        ||r_row.d1||r_row.d2||r_row.d3||r_row.d4||r_row.d5||r_row.d6||r_row.d7||r_row.d8;
   END LOOP;  
   dbms_output.put_line('mem2='||get_mem); 
   dbms_output.put_line(SYSTIMESTAMP - strt); 
END;

  PROCEDURE process_wide_row(r IN OUT NOCOPY typ_rec) IS
  BEGIN
      tmp := r.n1||r.n2||r.n3||r.n4||r.n5||r.n6||r.n7||r.n8||r.n9
        ||r.s1||r.s2||r.s3||r.s4||r.s5||r.s6
        ||r.d1||r.d2||r.d3||r.d4||r.d5||r.d6||r.d7||r.d8;
  END;    


..................
   strt := SYSTIMESTAMP;
   FOR i IN 1..t_row.count LOOP
      process_wide_row(t_row(i));
   END LOOP;  
   dbms_output.put_line(SYSTIMESTAMP - strt); 

+000000000 00:00:08.310970000