Earlier to this, I used the following commands to compile INVALID objects of any database 1. @?/rdbms/admin/utlrp 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); Ex; exec dbms_utility.compile_schema('SCOTT', FAlSE); We used “FALSE” as we have to compile invalids only not the whole schema.