EXEC DBMS_UTILITY.compile_schema(schema => 'JEPHE');

EXEC DBMS_UTILITY.compile_schema(schema => 'JEPHE');

run above command a few times, if the following command gets the same value before and after
running above command, then can stop run compilation.


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