Check Object Inventory & recently created objects

set lines 300
col  OBJECT_NAME for a50

SELECT OWNER, OBJECT_NAME,CREATED FROM DBA_OBJECTS
WHERE CREATED > SYSDATE -1
AND OWNER NOT IN  ('SYS','DBSNMP','SYSTEM','SYSMAN','RMAN','PUBLIC','PERFSTAT','OUTLN','APPQOSSYS','ORACLE_OCM')


SELECT OWNER, OBJECT_TYPE,COUNT(OBJECT_TYPE)
FROM DBA_OBJECTS
WHERE OWNER NOT IN ('SYS','DBSNMP','SYSTEM','SYSMAN','RMAN','PUBLIC','PERFSTAT','OUTLN','APPQOSSYS','ORACLE_OCM')
GROUP BY OWNER, OBJECT_TYPE
ORDER BY OWNER, OBJECT_TYPE;