Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>