DB count check for TABLES VIEWS PROCEDURES TRIGGERS
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