PL/SQL Packages DBMS_LIBCACHE

Prepare the library cache on an Oracle instance by extracting SQL and PL/SQL from a remote instance and compiling this SQL locally without execution.

Subprocedures:

COMPILE_CURSORS_FROM_REMOTE 
           Extract SQL in batch from the source instance and compile the SQL
           at the target instance. 

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

Related Commands:

Related Packages: