SELECT

  Username, Tbl, Idx, Syn, Vue, Seq, Proc, Func, Pkg, Trig

FROM

  (SELECT username, O.type#, O.obj#

   FROM sys.obj$ O, sys.dba_users U

   WHERE U.user_id = O.owner# (+)

  )

PIVOT

  (COUNT(obj#) FOR type# IN

    (2 AS Tbl,

     1 AS Idx,

     5 AS Syn,

     4 AS Vue,

     6 AS Seq,

     7 AS Proc,

     8 AS Func,

     9 AS Pkg,

     12 AS Trig )

  )

ORDER BY 2 DESC

/