select owner,name from v$db_object_cache where type like '%PROCE%' and locks >0 and pins >0;

发表于  2019-12-17 21:31:00 并被添加「」标签，阅读量： 930 。