Verificar objetos do schema

SELECT COUNT(OBJECT_TYPE), OBJECT_TYPE
FROM DBA_OBJECTS
WHERE OWNER LIKE 'USER%'
GROUP BY OBJECT_TYPE;