====== Oracle Invalid Objects ======
Note:  Run SQL below as SYS (connect as sysdba)\\
**Are there any invalid objects?**\\
<code>
select owner,object_type,object_name from dba_objects where status != 'VALID' order by owner, object_type;
</code>
**Rebuild all invalid PACKAGE/PACKAGE BODY etc.**\\
<code>
exec UTL_RECOMP.RECOMP_SERIAL ();
</code>
**Are there any bad indices?**\\
<code>
select owner, index_name from dba_indexes where status like 'UN%';
</code>