Recompile Selected schema's

If Situation we need to compile only some specific schema.

SQL>  EXEC UTL_RECOMP.recomp_parallel(4, 'SCOTT');

PL/SQL procedure successfully completed.

SQL>

SQL> select owner, status, count(*) from dba_objects where status ='INVALID' group by owner, status;

OWNER                          STATUS    COUNT(*)

------------------------------ ------- ----------

REPL1                          INVALID          8

SQL>

SQL>  EXEC UTL_RECOMP.recomp_parallel(4, 'REPL1')

PL/SQL procedure successfully completed.

SQL> show error

No errors.

SQL>

SQL> select owner, status, count(*) from dba_objects where status ='INVALID' group by owner, status;

OWNER                          STATUS    COUNT(*)

------------------------------ ------- ----------

REPL1                          INVALID          2

SQL>  EXEC UTL_RECOMP.recomp_parallel(4, 'SYS')

PL/SQL procedure successfully completed.

SQL>