select count(*),'CHAR$',part,object_type
from idl_char$,dba_objects
where obj#=object_id
and part=0
group by part,object_type
union
select count(*),'UB1$',part,object_type
from idl_ub1$,dba_objects
where obj#=object_id
and part=0
group by part,object_type
union
select count(*),'UB2$',part,object_type
from idl_ub2$,dba_objects
where obj#=object_id
and part=0
group by part,object_type
union
select count(*),'SB4$',part,object_type
from idl_sb4$,dba_objects
where obj#=object_id
and part=0
group by part,object_type
order by 2
/