Oracle: DBA_CATALOG

select
   count(*),
   table_type
from
   dba_catalog
group by
   table_type;

select
   table_name
from
   user_catalog
where
   table_type in ('TABLE', 'VIEW')
order by
   table_name;