SQL>
SQL> SELECT COUNT(*) num_owned, a.owner
2 FROM dba_objects a
3 WHERE 100<(SELECT COUNT(*) FROM dba_objects b
4 WHERE a.owner=b.owner)
5 GROUP BY a.owner;
NUM_OWNED OWNER
---------- ------------------------------
473 MDSYS
1143 FLOWS_020100
2769 PUBLIC
575 RNTSOFT
339 CTXSYS
449 SYSTEM
668 XDB
6631 SYS
8 rows selected.