腳本:

$ORACLE_HOME/rdbms/admin/utlrp.sql

其中會調用:

$ORACLE_HOME/rdbms/admin/utlrcmp.sql

在utlrp.sql腳本中，Oracle的注釋：

Rem utlrp.sql - UTiLity script Recompile invalid Pl/sql modules

Rem

Rem DESCRIPTION

Rem This is a fairly general script that can be used at any time to

Rem recompile all existing invalid PL/SQL modules in a database.

Rem

Rem If run as one of the last steps during migration/upgrade/downgrade

Rem (see the README notes for your current release and the Oracle

Rem Migration book), this script will validate all PL/SQL modules

Rem (PRocedures, functions, packages, triggers, types, views, libraries)

Rem during the migration step itself.

Rem

Rem Although invalid PL/SQL modules get automatically recompiled on use,

Rem it is useful to run this script ahead of time (e.g. as one of the last

Rem steps in your migration), since this will either eliminate or

Rem minimize subsequent latencies caused due to on-demand automatic

Rem recompilation at runtime.

Rem

Rem Oracle highly recommends running this script towards the end of

Rem of any migration/upgrade/downgrade.

注：上面這個示例是一個通用腳本，可以在任意時候運行以重新編譯數據庫失效對象。通常我們會在Oracle的升級指導中看到這個腳本，Oracle強烈推薦在migration/upgrade/downgrade之后，通過運行此腳本編譯失效對象。 但是注意,Oracle提醒，此腳本需要用SQLPLUS以SYSDBA身份運行，并且當時數據庫中最好不要有活動事物或DDL操作，否則極容易導致死鎖的出現（這是很容易理解的）。 只要仔細閱讀一下utlrcmp.sql腳本，大家就會知道Oracle的具體操作方式了。