select OWNER, NAME||' - '||TYPE object, SHARABLE_MEM from v$db_object_cache where SHARABLE_MEM > 10000 and type in ('PACKAGE','PACKAGE BODY','FUNCTION','PROCEDURE') order by SHARABLE_MEM desc

OWNER	OBJECT	SHARABLE_MEM
SYS	STANDARD - PACKAGE	377228
SYS	DBMS_PRVTAQIP - PACKAGE BODY	72285
SYS	DBMS_PRVTAQIP - PACKAGE	39609
SYS	DBMS_SPACE_ADMIN - PACKAGE	31960
SYS	DBMS_AQADM_SYSCALLS - PACKAGE	31911
SYS	DBMS_UTILITY - PACKAGE BODY	29648
SYS	STANDARD - PACKAGE BODY	26312
SYS	DBMS_STANDARD - PACKAGE	23633
SYS	DBMS_OUTPUT - PACKAGE	13011
SYS	DBMS_APPLICATION_INFO - PACKAGE	12465