1.select * from ALL_SOURCE where TYPE='PROCEDURE' AND NAME LIKE '%P_MONTHUSER%'
存储过程名匹配
2.select * from ALL_SOURCE where TYPE='PROCEDURE' AND TEXT LIKE '%p_monthuser%'
代码内容匹配
3.select * from all_objects where status = 'INVALID'
查询未编译通过的对象,包括存储过程和视图。