检查
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