SQL> select  banner
  2    from  v$version
  3  /

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE    12.1.0.2.0      Production
TNS for 64-bit Windows: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

Elapsed: 00:00:00.02
SQL> set timing on
SQL> set serveroutput on
SQL> declare
  2      v_cnt number;
  3  begin
  4      select count(*) into v_cnt from DBA_SOURCE,(select * from dual connect by level <= 5);
  5      dbms_output.put_line('COUNT(*) = ' || v_cnt);
  6  end;
  7  /
COUNT(*) = 1775375

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.68
SQL> declare
  2      type typeTable is table of DBA_SOURCE%rowtype;
  3      varBulkTable typeTable;
  4  begin
  5      select d.* bulk collect into    varBulkTable from DBA_SOURCE d,(select * from dual connect by level <= 5);
  6      dbms_output.put_line('COUNT(*) = ' || varBulkTable.COUNT);
  7  end;
  8  /
COUNT(*) = 1775375

PL/SQL procedure successfully completed.

Elapsed: 00:00:03.26
SQL> declare
  2      v_cnt number;
  3  begin
  4      select count(*) into v_cnt from DBA_SOURCE,(select * from dual connect by level <= 10);
  5      dbms_output.put_line('COUNT(*) = ' || v_cnt);
  6  end;
  7  /
COUNT(*) = 3550750

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.87
SQL> declare
  2      type typeTable is table of DBA_SOURCE%rowtype;
  3      varBulkTable typeTable;
  4  begin
  5      select d.* bulk collect into    varBulkTable from DBA_SOURCE d,(select * from dual connect by level <= 10);
  6      dbms_output.put_line('COUNT(*) = ' || varBulkTable.COUNT);
  7  end;
  8  /
declare
*
ERROR at line 1:
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-06512: at line 5


Elapsed: 00:00:07.79
SQL>