SQL> select Owner,
2 Name,
3 Type,
4 Source_Size+Code_Size+Parsed_Size+Error_Size Total_Bytes
5 from DBA_OBJECT_SIZE
6 where Type in ('PACKAGE BODY','PROCEDURE') and rownum < 10
7 order by 4 desc;
OWNER NAME TYPE TOTAL_BYTES
------------------------------ ------------------------------ ------------- -----------
SYS DIUTIL PACKAGE BODY 59325
DBMS_REGISTRY PACKAGE BODY 47351
DIANA PACKAGE BODY 45907
STANDARD PACKAGE BODY 34458
PIDL PACKAGE BODY 16577
PSTUB PROCEDURE 3812
PSTUBT PROCEDURE 2753
XML_SCHEMA_NAME_PRESENT PACKAGE BODY 2728
SUBPTXT2 PROCEDURE 2469
SQL>