select owner, tablespace_name, count(*) from dba_segments where owner = 'BPROSOCIAL' group by owner, tablespace_name;