Compiling packages | Oracle DBA Tutorial pdf

SQL and PL/SQL

All source code of packages, procedures and functions are written in
DBA_SOURCE, ALL_SOURCE or USER_SOURCE views.
=> Compiling packages
ALTER PROCEDURE procedure COMPILE
ALTER PACKAGE package COMPILE
ALTER PACKAGE package COMPILE BODY