Oracle PL/SQL Tutorial/System Tables Data Dictionary/DBA OBJECT SIZE
Search DBA_OBJECT_SIZE for package and procedure size
<source lang="sql">
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> SQL> SQL></source>