Oracle组件

检查

promp check db comp
col COMP_NAME for a40
col status for a10
col version for a15
select 
/*+ 
gather_plan_statistics 
monitor
part: db_info.sql
subpart: db_comp
*/
comp_name
,version
,status 
from dba_registry 
order by 1
/
promp
 

输出：

COMP_NAME                                VERSION         STATUS
---------------------------------------- --------------- ----------
Oracle Database Catalog Views            11.2.0.4.0      VALID
Oracle Database Packages and Types       11.2.0.4.0      VALID
Oracle Workspace Manager                 11.2.0.4.0      VALID

组件失效：

set linesize 150
set pagesize 900
col compilesql for a80
select 
 case when object_type='PACKAGE BODY' then 'alter package '||owner||'.'||object_name||' compile body;'
      when object_type='TYPE BODY' then 'alter type '||owner||'.'||object_name||' compile body;'
 else 'alter '||object_type||' '||owner||'.'||object_name||' compile ;'
 end compilesql
from (
 select owner,object_type,object_name from dba_objects where owner in
 (select username from dba_users)
and status <>'VALID'
and object_type <>'SYNONYM'
)
order by object_type,object_name
/

全库编译 @?/rdbms/admin/utlrp.sql