| 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 |
| TYPES_ONLY |
PLS_INTEGER |
64 |
|
| Dependencies |
| DBA_SCHEDULER_JOBS |
DBMS_UTILITY |
UTL_IDENT |
| DBA_SCHEDULER_RUNNING_JOBS |
DEPENDENCY$ |
UTL_RECOMP_ALL_OBJECTS |
| DBMS_INTERNAL_LOGSTDBY |
GV$PARAMETER |
UTL_RECOMP_COMPILED |
| DBMS_LOCK |
JOB_DEFINITION |
UTL_RECOMP_ERRORS |
| DBMS_RANDOM |
JOB_DEFINITION_ARRAY |
UTL_RECOMP_INVALID_JAVA_SYN |
| DBMS_REGXDB |
PLITBLM |
UTL_RECOMP_INVALID_SEQ |
| DBMS_SCHEDULER |
SYS_STUB_FOR_PURITY_ANALYSIS |
UTL_RECOMP_SORTED |
| DBMS_STATS |
|
|
|
| Security Model |
No explicit grants made. This package as of 11.2.0.2 supports TimesTen |
| Subprograms |
|
| |
| PARALLEL_SLAVE |
| An internal function that runs in each parallel thread to recompile invalid objects from utl_recomp_sorted |
utl_recomp.parallel_slave(flags IN PLS_INTEGER); |
| Internal to package |
| |
| RECOMP_PARALLEL |
| Recompiles 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 schema objects using the default degree of parallelism |
exec utl_recomp.recomp_parallel(NULL, 'UWCLASS'); |
| Recompiles all objects using 2 parallel threads and allows other applications to use the job queue concurrently |
exec utl_recomp.recomp_parallel(2, NULL, utl_recomp.random_order); |
| |
| 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 |
| Are there invalid database objects |
SELECT owner, object_type, COUNT(*)
FROM dba_objects
WHERE status = 'INVALID'
GROUP BY owner, object_type; |
| Is a UTL_RECOMP job currently running |
SELECT job_name
FROM dba_scheduler_running_jobs
WHERE job_name LIKE 'UTL_RECOMP_SLAVE_%'; |
