Insert as Select -> ORA-07445

Ouch! We got a wonderful ORA-03113 running a PL/SQL procedure last week. Just two seconds after executing the routine via SQL-Plus the session was terminated with an ORA-03113 end-of-file on communications channel. This happend both on a linux box and an AIX system both running Oracle 9.2.0.6.
Infact the procedure was crashing with a memory access vialotion. This could be seen after taking a look in the oracle alertlog.
Oracle support was able to analyse the problem and match it to a known bug 3256015 and suggest installing an available patch 3256015 - which we did... and hey presto the procedure works fine now.