select count(*), object_type
from dba_objects
where STATUS='INVALID'
group by object_type;
SQL> @invobj
COUNT(*) OBJECT_TYPE
---------- -----------------------
2 PROCEDURE
5137 VIEW
57 TRIGGER
157 FUNCTION
3 MATERIALIZED VIEW
13 SYNONYM
13749 PACKAGE BODY
2993 PACKAGE
compile objects via script:
APPS_PASS=apps
SYSTEM_PASS=manager
sqlplus -s APPS/$APPS_PASS @$AD_TOP/sql/adutlrcmp.sql APPLSYS $APPS_PASS APPS $APPS_PASS $SYSTEM_PASS 0 0 NONE FALSE