dbawiki

• 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:

<code> exec utl_recomp.recomp_serial();