SELECT DISTINCT(TABLESPACE_NAME) FROM ALL_TABLES;

SELECT COUNT(*) FROM ALL_TABLES where TABLESPACE_NAME='XX';

  COUNT(*)

----------

       383

SELECT DISTINCT(OWNER) FROM ALL_VIEWS;

SELECT COUNT(*) FROM ALL_VIEWS WHERE OWNER='XX';

  COUNT(*)

----------

       169

SELECT DISTINCT(OWNER) FROM ALL_PROCEDURES;

SELECT COUNT(*) FROM ALL_PROCEDURES WHERE OWNER='XX';

  COUNT(*)

----------

       141

SELECT DISTINCT(OWNER) FROM ALL_TRIGGERS;

SELECT COUNT(*) FROM ALL_TRIGGERS WHERE OWNER='XX';

  COUNT(*)

----------

       134

SELECT COUNT(*) FROM ALL_INDEXES WHERE OWNER='XX';

  COUNT(*)

----------

       672