Spatial 10.2.0.4.0 VALID
Oracle interMedia 10.2.0.4.0 VALID
Oracle Enterprise Manager 10.2.0.4.0 VALID
Oracle XML DATABASE 10.2.0.4.0 VALID
Oracle Text 10.2.0.4.0 VALID
Oracle Expression FILTER 10.2.0.4.0 VALID
Oracle Rules Manager 10.2.0.4.0 VALID
Oracle Workspace Manager 10.2.0.4.3 VALID
Oracle DATA Mining 10.2.0.4.0 VALID
Oracle DATABASE Catalog Views 10.2.0.4.0 VALID
Oracle DATABASE Packages AND Types 10.2.0.4.0 VALID
JServer JAVA Virtual Machine 10.2.0.4.0 VALID
Oracle XDK 10.2.0.4.0 VALID
Oracle DATABASE Java Packages 10.2.0.4.0 VALID
OLAP Analytic Workspace 10.2.0.4.0 REMOVED
Oracle OLAP API 10.2.0.4.0 REMOVED
16 ROWS selected.
针对不同版本，remove OLAP组件，请参看如下文档：
Master Note FOR Oracle XML DATABASE (XDB) Install / Deinstall [ID 1292089.1]
7. Recomplied(or clear) invalid objects
首先运行utlrp.sql，对于无效对象，跟应用确认如下可以删除：
DROP PROCEDURE "DMSB01.UPDATE_VINORDER" ;
DROP PROCEDURE "DMSB01.UPDATE_ORDE_STATUS" ;
DROP PROCEDURE CLEAN_WSTCLEP_DUP ;
DROP PROCEDURE CONV_LONG_VARCHAR ;
DROP PROCEDURE OVEH_MIGRATION ;
DROP PROCEDURE GEN_CUST_ID2 ;
DROP PROCEDURE BILL_MIGRATION ;
DROP PROCEDURE GEN_BILL_NO ;
DROP PROCEDURE BILL_REPM_MAIGRAION ;
DROP PROCEDURE BILL_REPL_MIGRATION ;
DROP PROCEDURE GEN_CUST_ID ;
DROP PROCEDURE REPP_MIGRATION ;
DROP PROCEDURE REPM_MIGRATION ;
DROP PROCEDURE REPL_MIGRATION ;
DROP PROCEDURE CLPP_MIGRATION ;
DROP PROCEDURE CLOP_MIGRATION ;
DROP PROCEDURE CLAIM_MIGRATION ;
DROP PROCEDURE TEST ;
DROP PROCEDURE GEN_CLAIM_NO ;
DROP PROCEDURE BILL_REPP_MIGRATION ;
DROP FUNCTION DRS.CCC ;
DROP VIEW DRS.V_20110601_03_01_02SP_PZ ;
DROP VIEW DRS.V_20110901_03_01_02SP_PZ ;
DROP VIEW DRS.V_20110401_03_01_02SP_PZ ;
DROP VIEW DRS.V_TJ_0901_FQHZ ;
DROP VIEW DRS.V_TJ_1008_FQHZ ;
DROP VIEW DRS.V_20110503_03_01_02SP_PZ ;
DROP VIEW DRS.V_TJ_0802_FQHZ ;
DROP VIEW DRS.V_20110704_03_01_02SP_PZ ;
DROP VIEW DRS.V_20110801_03_01_02SP_PZ ;
8. 清理回收站
-- select count(*) from dba_recyclebin;
-- purge dba_recyclebin
SQL> PURGE DBA_RECYCLEBIN;
DBA Recyclebin purged.
9. Check again
-- select cocunt(*) from dba_objects where status='INVALID';
-- 再次运行utlu112i.sql
10. 收集统计
运行如下脚本即可（需要从metalink下载）：
check_schema_stale_stats.sql
执行情况如下：
SQL> @ check_stale_stats.SQL
-------------------------------------------------------------------------------------------------------
-- CTXSYS schema contains stale statistics use the following