| General Information |
| Purpose |
Utility package for dependency-based
recompilation of invalid objects sequentially or in parallel |
| Source |
$ORACLE_HOME/rdbms/admin/utlrcmp.sql |
| Constants |
| Name |
Data Type |
Value |
| COMPILE_LOG (Obsolete) |
PLS_INTEGER |
2 |
| NO_REUSE_SETTINGS (Obsolete) |
PLS_INTEGER |
4 |
| RANDOM_ORDER |
PLS_INTEGER |
8 |
| REVERSE_ORDER |
PLS_INTEGER |
16 |
| SPECS_ONLY |
PLS_INTEGER |
32 |
|
| Dependencies |
|
DBA_SCHEDULER_JOBS |
PLITBLM |
|
DBA_SCHEDULER_RUNNING_JOBS |
UTL_RECOMP_ALL_OBJECTS |
|
DBMS_RANDOM |
UTL_RECOMP_COMPILED |
|
DBMS_SCHEDULER |
UTL_RECOMP_ERRORS |
|
DBMS_STATS |
UTL_RECOMP_INVALID_JAVA_SYN |
|
DBMS_UTILITY |
UTL_RECOMP_INVALID_PARALLEL |
|
DEPENDENCY$ |
UTL_RECOMP_INVALID_SEQ |
|
GV$PARAMETER |
UTL_RECOMP_SORTED |
|
| Required Object Privilege |
GRANT execute ON utl_recomp TO <schema_name>; |
| GRANT execute ON utl_recomp TO uwclass; |
| |
| PARALLEL_SLAVE |
| An internal function that runs in each
parallel thread. It picks up any remaining invalid objects from utl_recomp_sorted and recompiles them |
utl_recomp.parallel_slave(flags IN
PLS_INTEGER) |
| Internal to package |
| |
| RECOMP_PARALLEL |
| Recompile all objects using 4 parallel threads |
utl_recomp.recomp_parallel(
threads PLS_INTEGER := NULL,
schema VARCHAR2 := NULL,
flags PLS_INTEGER := 0); |
| exec utl_recomp.recomp_parallel(4); |
|
Recompile objects in schema JOE using the number of threads specified in the parameter JOB_QUEUE_PROCESSES |
exec utl_recomp.recomp_parallel(NULL, <schema_name>); |
|
exec utl_recomp.recomp_parallel(NULL, 'UWCLASS'); |
| Recompile all objects using 2 parallel threads, but allow other
applications to use the job queue concurrently |
utl_recomp.recomp_parallel(<number_of_parallel_threads>,
NULL, utl_recomp.share_job_queue); |
|
exec utl_recomp.recomp_parallel(2, NULL, utl_recomp.share_job_queue); |
| |
| RECOMP_SERIAL |
| Recompile all objects sequentially |
utl_recomp.recomp_serial; |
| exec utl_recomp.recomp_serial; |
| Recompile all objects in a schema sequentially |
utl_recomp.recomp_serial(
schema VARCHAR2 := NULL,
flags PLS_INTEGER := 0); |
|
exec utl_recomp.recomp_serial('UWCLASS'); |
| |
| UTL_RECOMP Related Queries |
| Is a UTL_RECOMP job currently running |
SELECT job_name
FROM dba_scheduler_running_jobs
WHERE job_name LIKE 'UTL_RECOMP_SLAVE_%'; |
