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_%'; |