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


Connect time(ms): 93

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 16

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

