Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
This script provides a packaged interface to recompile invalid PL/SQL modules, Java classes, indextypes and operators in a database sequentially or in parallel.
This package can handle the recompile of any database or container with the sole exception of PDB$SEED which is, by definition, READ ONLY. If PDB$SEED contains invalid objects your database is toast or, at the least, PDB$SEED, is unusable.
AUTHID
DEFINER
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
NEW_EDITION
PLS_INTEGER
128
Dependencies
DBA_SCHEDULER_JOBS
DBMS_SCHEDULER
UTL_IDENT
DBA_SCHEDULER_RUNNING_JOBS
DBMS_STATS
UTL_RECOMP_ALL_OBJECTS
DBMS_EDITIONS_UTILITIES
DBMS_UTILITY
UTL_RECOMP_COMPILED
DBMS_INTERNAL_LOGSTDBY
DEPENDENCY$
UTL_RECOMP_ERRORS
DBMS_LOCK
GV$PARAMETER
UTL_RECOMP_INVALID_ALL
DBMS_OBJECTS_APPS_UTILS
JOB_DEFINITION
UTL_RECOMP_SKIP_LIST
DBMS_RANDOM
JOB_DEFINITION_ARRAY
UTL_RECOMP_SORTED
DBMS_REGXDB
PLITBLM
Documented
Yes
First Available
12.1.0
Security Model
Owned by SYS with no privileges granted. As of version 11.2.0.2 supports TimesTen.