Oracle PL/SQL/System Tables Views/user object size
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>