Query to Check Database for Invalid Objects

The relevant query is as follows:

SELECT owner, object_name, object_type

FROM     all_objects

WHERE  status = ‘INVALID’;

SELECT count(*)

FROM   from dba_objects

WHERE  status = ‘INVALID’;