Compile INVALIDS of any SCHEMA
Earlier to this, I used the following commands to compile INVALID objects of any database
2. exec utl_recomp.recomp_parallel(threads=>5)
3. alter package/ procedure compile ... comand
I found one more utility that will help us to compile the invalids of any particular schema
exec dbms_utility.compile_schema('<schema_name>', FAlSE);
exec dbms_utility.compile_schema('SCOTT', FAlSE);
We used “FALSE” as we have to compile invalids only not the whole schema.