col username for a20
select   USERNAME,
         substr(count(decode(o.TYPE#, 2,o.OBJ#,'')),1,5) as Tabs,
         substr(count(decode(o.TYPE#, 1,o.OBJ#,'')),1,5) as Indx,
         substr(count(decode(o.TYPE#, 5,o.OBJ#,'')),1,5) as Syns,
         substr(count(decode(o.TYPE#, 4,o.OBJ#,'')),1,5) as Views,
         substr(count(decode(o.TYPE#, 6,o.OBJ#,'')),1,5) as Seqs,
         substr(count(decode(o.TYPE#, 7,o.OBJ#,'')),1,5) as Procs,
         substr(count(decode(o.TYPE#, 8,o.OBJ#,'')),1,5) as Funcs,
         substr(count(decode(o.TYPE#, 9,o.OBJ#,'')),1,5) as Pkgs,
         substr(count(decode(o.TYPE#,12,o.OBJ#,'')),1,5) as Trigs,
         substr(count(decode(o.TYPE#,10,o.OBJ#,'')),1,5) as Deps
from     sys.obj$ o, dba_users u
where    u.USER_ID = o.OWNER# (+)
and      o.TYPE# is NOT NULL
and      u.username not in ('SYS','SYSTEM','OUTLN','XDB','WMSYS')
group by USERNAME
order by USERNAME;

hostgator