SQL>
SQL> SELECT COUNT(username) users, default_tablespace
2 FROM dba_users
3 where rownum<50
4 GROUP BY default_tablespace
5 /
USERS DEFAULT_TABLESPACE
---------- ------------------------------
6 SYSAUX
2 USERS
7 SYSTEM
SQL>