SELECT owner, COUNT (*)
    FROM dba_objects
   WHERE status != 'VALID'
GROUP BY ROLLUP (OWNER)

ZIM4_RO	71
ZIM4	73
PUBLIC	16
SYS	35
	195

SELECT owner,
       object_name,
       object_type,
       status
  FROM dba_objects
 WHERE status != 'VALID' AND owner = 'SYS'

SYS	DBMS_DEFER_SYS	PACKAGE BODY	INVALID
SYS	DBMS_DEFER_IMPORT_INTERNAL	PACKAGE BODY	INVALID
SYS	DBMS_SNAPSHOT_UTL	PACKAGE BODY	INVALID
SYS	DBMS_IREFRESH	PACKAGE BODY	INVALID
SYS	DBMS_DEFERGEN_WRAP	PACKAGE BODY	INVALID
SYS	DBMS_DEFER_QUERY_UTL	PACKAGE BODY	INVALID
SYS	DBMS_DEFER_ENQ_UTL	PACKAGE	INVALID
SYS	DBMS_DEFER_ENQ_UTL	PACKAGE BODY	INVALID
SYS	DBMS_ASYNCRPC_PUSH	PACKAGE BODY	INVALID
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	INVALID
SYS	DBMS_DEFER_INTERNAL_SYS	PACKAGE BODY	INVALID
SYS	DBMS_DEFER	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_UTL	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_SNA_UTL	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_UNTRUSTED	PACKAGE BODY	INVALID
SYS	DBMS_DEFER_REPCAT	PACKAGE BODY	INVALID
SYS	DBMS_OFFLINE_RGT	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_CONF	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_MAS	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT	PACKAGE BODY	INVALID
SYS	DBMS_INTERNAL_REPCAT	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_RPC	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_UTL2	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_UTL3	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_MIG_INTERNAL	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_FLA_MAS	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_RQ	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_ADD_MASTER	PACKAGE BODY	INVALID
SYS	DBMS_OFFLINE_INTERNAL	PACKAGE BODY	INVALID
SYS	DBMS_OFFLINE_OG	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_RGT_UTL	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_RGT	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_RGT_ALT	PACKAGE BODY	INVALID
SYS	DBMS_REPCAT_RGT_CUST2	PACKAGE BODY	INVALID
SYS	DBMS_IAS_MT_INST	PACKAGE BODY	INVALID

select comp_id, status, schema, version 
from dba_registry order by 1;

  SELECT comp_id,
         status,
         schema,
         version
    FROM dba_registry
ORDER BY 1;

CATALOG	VALID	SYS	10.2.0.4.0
CATJAVA	VALID	SYS	10.2.0.4.0
CATPROC	VALID	SYS	10.2.0.4.0
EXF	VALID	EXFSYS	10.2.0.4.0
JAVAVM	VALID	SYS	10.2.0.4.0
OWM	VALID	WMSYS	10.2.0.4.3
XML	VALID	SYS	10.2.0.4.0

-- E. Nossova, Product TuTool : www.tutool.de

set heading on
set pagesize 1000
set verify off
set feedback off
set linesize 1000

col object_name format a30
col subobject_name format a30
col temporary format a9
col generated format a9
col secondary format a9
col owner format a20
col error_text format a60

clear breaks
break on owner on object_type on object_name on subobject_name 

/* reports invalid objects*/

select o.owner, o.object_type, o.object_name, o.subobject_name, o.status, decode(e.text,null,'','line '||
ltrim(to_char(e.line,'99999999'))||' : '||substr(e.text,1,230)) 
error_text
from sys.dba_errors e, sys.dba_objects o
where
status != 'VALID' and
o.owner = e.owner (+) and
o.object_name = e.name (+) and
o.object_type = e.type (+)
order by o.owner, o.object_type, o.object_name, o.subobject_name, e.line
/

set linesize 80