oracle

SELECT * FROM User_Source WHERE type='PROCEDURE' and NAME LIKE '%B601A_CON%';
select *from dba_objects t where t.owner='NEW_CLEAN_IND_CUSTOMIZE_UT' AND t.OBJECT_TYPE = 'PROCEDURE' AND  t.OBJECT_NAME LIKE '%B601%' ;
select *from dba_objects t where t.owner='NEW_CLEAN_IND_CUSTOMIZE_UT' AND t.status='INVALID';

--查看正在运行的存储过程
select name,locks,pins
 from v$db_object_cache
 where locks > 0 and pins > 0 and type='PROCEDURE';

 

SELECT * FROM User_Source WHERE type='PROCEDURE' and NAME LIKE '%B601A_CON%';
select *from dba_objects t where t.owner='NEW_CLEAN_IND_CUSTOMIZE_UT' AND t.OBJECT_TYPE = 'PROCEDURE' AND  t.OBJECT_NAME LIKE '%B601%' ;
select *from dba_objects t where t.owner='NEW_CLEAN_IND_CUSTOMIZE_UT' AND t.status='INVALID';

--查看正在运行的存储过程
select name,locks,pins
 from v$db_object_cache
 where locks > 0 and pins > 0 and type='PROCEDURE';