objcount.sql

select object_type,status,count(*)          
from user_objects                           
group by object_type,status;