Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query user_object_size table

SQL> SQL> SQL> SELECT name, type, source_size, parsed_size, code_size   2  FROM   user_object_size   3  WHERE  type IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION', 'TRIGGER')   4         and rownum < 50   5  ORDER BY type, name; NAME                           TYPE          SOURCE_SIZE PARSED_SIZE  CODE_SIZE ------------------------------ ------------- ----------- ----------- ---------- COMPUTE_DISCOUNTS              FUNCTION              566         251        572 DATE_RANGE                     FUNCTION              749         531        734 NEW_ADD_MONTHS                 FUNCTION              443         308        524 PIPELINEME                     FUNCTION              219         202        890 UPDATETEMP                     FUNCTION              183         410        433 VALIDATE_DATE_FORMAT           FUNCTION              385         267        666 DEBUG                          PACKAGE               301         698        457 DEPENDEE                       PACKAGE                71         234        185                                                                                                                                       Page           1 NAME                           TYPE          SOURCE_SIZE PARSED_SIZE  CODE_SIZE ------------------------------ ------------- ----------- ----------- ---------- GLOBAL_DEF                     PACKAGE               135         342        310 LOGPKG                         PACKAGE               124         349        264 NATIVEDYNAMIC                  PACKAGE               217         429        276 STUDENTDATA                    PACKAGE               280         642        507 TRIGPACKAGE                    PACKAGE                59         193        220 DEBUG                          PACKAGE BODY         1407           0          0 DEPENDEE                       PACKAGE BODY          150           0        366 GLOBAL_DEF                     PACKAGE BODY          438           0        505                                                                                                                                       Page           2 NAME                           TYPE          SOURCE_SIZE PARSED_SIZE  CODE_SIZE ------------------------------ ------------- ----------- ----------- ---------- LOGPKG                         PACKAGE BODY          410           0          0 NATIVEDYNAMIC                  PACKAGE BODY          668           0        625 ANALYZE_OEM                    PROCEDURE             521         460        934 DEPENDER                       PROCEDURE              89         515        321 DYNAMICPLSQL                   PROCEDURE            1103           0          0 DYNAMICQUERY                   PROCEDURE            1446           0          0 EXAMPLE_PROC1                  PROCEDURE             424           0          0 HIKE_PRICES                    PROCEDURE             241         355        326                                                                                                                                       Page           3 NAME                           TYPE          SOURCE_SIZE PARSED_SIZE  CODE_SIZE ------------------------------ ------------- ----------- ----------- ---------- MY_FIRST_PROC                  PROCEDURE             160         332        327 PRINTTOTALROWS                 PROCEDURE             827           0          0 REVERSELOB                     PROCEDURE            1127        2071        678 SHOWEMPS                       PROCEDURE             885         525       1242 TEMPINSERT                     PROCEDURE             184         329        540 UPDATECLASSES                  PROCEDURE             721         775        720                                                                                                                                       Page           4 30 rows selected. SQL> SQL>