Script to check Invalid object counts in database

----->INVALID_OBJECT_CHECK
*******************************

#Full_Invalid_object_Details
=======================

set lines 300 pages 300
col owner for a10
col OBJECT_NAME for a30
select count(*),OBJECT_NAME,object_type,owner,status,timestamp from dba_objects where
status='INVALID' group by object_name,object_type,owner,status,timestamp order by timestamp desc;

#Invalid object count under schema#
================================

select count(*),object_type,owner from dba_objects where status='INVALID' group by object_type,owner;

#Only_count
===========

 select count(*),status from dba_objects group by status;

#Last_DDL_Time
==============

select owner,object_name,object_type,status,last_ddl_time from dba_objects where object_name in
('CALCULATE_GAIN_LOSS')


select owner,object_type,count(*) from dba_objects where owner='&1' group by object_type,owner;