CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle UTL_RECOMP
Version 11.1
 
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_%';
 
Related Topics
DBMS_UTILITY.COMPILE_SCHEMA
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [136 users online]    © 2010 psoug.org