Oracle PL/SQL Tutorial/System Tables Data Dictionary/DBA OBJECT SIZE

Материал из SQL эксперт
Перейти к: навигация, поиск

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>