SELECT u.username,
       SUM(DECODE(o.object_type, 'INDEX', 1)) "INDEX",
       SUM(DECODE(o.object_type, 'TABLE', 1)) "TABLE",
       SUM(DECODE(o.object_type, 'CLUSTER', 1)) "CLUSTER",
       SUM(DECODE(o.object_type, 'VIEW', 1)) "VIEW",
       SUM(DECODE(o.object_type, 'SYNONYM', 1)) "SYNONYM",
       SUM(DECODE(o.object_type, 'SEQUENCE', 1)) "SEQUENCE",
       SUM(DECODE(o.object_type, 'PROCEDURE', 1)) "PROCEDURE",
       SUM(DECODE(o.object_type, 'FUNCTION', 1)) "FUNCTION",
       SUM(DECODE(o.object_type, 'PACKAGE', 1)) "PACKAGE",
       SUM(DECODE(o.object_type, 'PACKAGE BODY', 1)) "PACKAGE BODY",
       SUM(DECODE(o.object_type, 'TRIGGER', 1)) "TRIGGER",
       SUM(DECODE(o.object_type, 'TYPE', 1)) "TYPE",
       SUM(DECODE(o.object_type, 'TYPE BODY', 1)) "TYPE BODY",
       SUM(DECODE(o.object_type, 'TABLE PARTITION', 1)) "TABLE PARTITION",
       SUM(DECODE(o.object_type, 'INDEX PARTITION', 1)) "INDEX PARTITION",
       SUM(DECODE(o.object_type, 'LOB', 1)) "LOB",
       SUM(DECODE(o.object_type, 'LIBRARY', 1)) "LIBRARY",
       SUM(DECODE(o.object_type, 'DIRECTORY', 1)) "DIRECTORY",
       SUM(DECODE(o.object_type, 'JAVA SOURCE', 1)) "JAVA SOURCE",
       SUM(DECODE(o.object_type, 'JAVA CLASS', 1)) "JAVA CLASS",
       SUM(DECODE(o.object_type, 'JAVA RESOURCE', 1)) "JAVA RESOURCE",
       SUM(DECODE(o.object_type, 'INDEXTYPE', 1)) "INDEXTYPE",
       SUM(DECODE(o.object_type, 'OPERATOR', 1)) "OPERATOR",
       SUM(DECODE(o.object_type, 'RESOURCE PLAN', 1)) "RESOURCE PLAN",
       SUM(DECODE(o.object_type, 'CONSUMER GROUP', 1)) "CONSUMER GROUP",
       SUM(DECODE(o.object_type, 'JAVA DATA', 1)) "JAVA DATA"
  FROM dba_objects o, dba_users u
 WHERE o.owner = u.username
 GROUP BY u.username