Wednesday 10 November 2021

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>