View Triggers Function Procedure

check view total number

select count(VIEW_NAME) from USER_VIEWS;

check trigger total number

select COUNT(*) from USER_TRIGGERS;

check procedure,check functions

SELECT OBJECT_NAME,OBJECT_TYPE FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE') AND OWNER='XX';