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