Search DBA_OBJECT_SIZE for package and procedure size : DBA_OBJECT_SIZE « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. DBA_OBJECT_SIZE

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>