*Connect to an Oracle database as user sys

*Check to see how many objects are invalid: select count('e') from dba_objects where status='INVALID';

*Recompile all invalid objects: exec utl_recomp.recomp_serial();