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