validate objects

http://www.oracle-base.com/articles/misc/RecompilingInvalidSchemaObjects.php

select object_type, count(*) from dba_objects where owner in 'ownername' group by object_type

select object_name, object_type from dba_objects where owner in 'ownername' order by object_name
/

select count(*), object_type from user_objects group by object_type
/

select owner, count(*) from dba_objects group by owner
/