SYS@sen>select owner,name,type from v$db_object_cache where SHARABLE_MEM>10000 AND (TYPE='PACKAGE'
OR TYPE='PACKAGE BODY' OR TYPE='FUNCTION' OR TYPE='PROCEDURE') AND kept='NO';
3,在scott用户下新建一个procedure
create or replace procedure p1 as begin null; end;
DBA_objects查看,注意这里scott需要大写
SYS@sen>select owner, object_type,OBJECT_NAME from DBA_objects where object_type='PROCEDURE' and owner='SCOTT';