Find

compile invalid object

select count(*) from dba_objects where status='INVALID';

How to compile in sqlplus
sqlplus '/as sysdba'
-- Database level.
EXEC UTL_RECOMP.recomp_serial();
EXEC UTL_RECOMP.recomp_parallel(4);