9i ORA-06508 Program unit being called cannot be found UNTIL restart

This could be a problem with the DBMS_SQL package. Try to run the catproc.sql as sys and see if you are still having a problem.

To find the value of your sga log into sqlplus and type show sga.