SQL>
SQL> SELECT COUNT(*) num_owned, a.owner
2 FROM dba_objects a
3 WHERE a.owner NOT IN (SELECT b.owner FROM dba_objects b
4 WHERE b.owner LIKE 'S%')
5 GROUP BY a.owner;
NUM_OWNED OWNER
---------- ------------------------------
473 MDSYS
3 TSMSYS
1143 FLOWS_020100
2769 PUBLIC
8 OUTLN
575 RNTSOFT
339 CTXSYS
34 HR
12 FLOWS_FILES
46 DBSNMP
668 XDB
11 rows selected.
SQL>