How direct-path inserts and one extra row per loop bloated 18 MB into 8 GB

I was investigating the code that looked something like this: truncate table t1; for i in 1..300 loop insert /*+ append */ into t1 select 1 from dual connect by level <= p_connect_by_level;