Oracle PL/SQL/System Tables Views/DBA OBJECT SIZE

Search DBA_OBJECT_SIZE for package and procedure 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>