Oracle PL/SQL Tutorial/System Tables Data Dictionary/user object size

Query user_object_size

   <source lang="sql">

SQL> SQL> COLUMN source_size FORMAT 999,999 SQL> COLUMN parsed_size FORMAT 999,999 SQL> COLUMN code_size FORMAT 999,999 SQL> SELECT name, type, source_size, parsed_size, code_size

 2  FROM      user_object_size
 3  where      rownum < 50
 4  ORDER BY  type, name;

CHITIME FUNCTION 86 275 413 IS_OVERDUE FUNCTION 273 459 486 NO_RETURN FUNCTION 386 473 531 ORD_GENERATOR_PIPED FUNCTION 248 364 1,464 PRED_FUNCTION FUNCTION 113 301 274 RULERSTR FUNCTION 138 246 414 SOME_FUNCTION FUNCTION 171 283 469 TO_NUMBER_OR_NULL FUNCTION 212 261 317 CLEAN_SCHEMA PACKAGE 49 179 181

DATECALC PACKAGE 201 502 323 DEMO_PKG PACKAGE 138 363 272 DESCCOLS PACKAGE 701 1,473 1,194 DIANA_SIZE PACKAGE 139 320 197

ERRPKG PACKAGE 60 182 189 GRP PACKAGE 368 777 587 HR_APP PACKAGE 143 416 386 MULTDIM PACKAGE 898 1,268 1,010 MYPACKAGE1 PACKAGE 45 175 177 MY_DATE PACKAGE 84 251 189 ORDER_ENTRY PACKAGE 324 673 326 ORGMASTER2 PACKAGE 796 1,624 726 PLW7203 PACKAGE 136 365 294

PROCESORDERS PACKAGE 89 248 256 A PROCEDURE 59 255 358 BB PROCEDURE 33 165 211 BIND PROCEDURE 370 511 1,180

CREATE_DYN_TABLE PROCEDURE 690 661 1,035 CREATE_DYN_TABLE2 PROCEDURE 662 662 1,011 CREATE_TABLE PROCEDURE 109 474 372 CREATE_WRAPPED_TEST PROCEDURE 403 403 1,181 DBMSSQL_ARRAY PROCEDURE 1,439 662 1,476 DO_MOD PROCEDURE 281 455 706 DYNPLSQL PROCEDURE 113 515 500 ERROR_TEST1 PROCEDURE 257 460 468 FLUSH PROCEDURE 37 168 209

GEN_MULTCOLL PROCEDURE 1,745 595 2,233 LOADARRAY PROCEDURE 331 393 1,321 PRINT_TABLE PROCEDURE 966 535 1,772 PROC3 PROCEDURE 296 379 777

RANDOM PROCEDURE 543 455 833 SEARCHED_CASE PROCEDURE 217 387 594 SHOW_ORDERS PROCEDURE 1,323 574 1,616 TEST_EMPLOYEE_CURSORS PROCEDURE 384 275 1,765 TOTAL_CUSTOMER PROCEDURE 1,051 515 3,385 UPDATE_DYN_FOR_ALL_ORDERS PROCEDURE 711 646 964 UPDNUMVAL PROCEDURE 590 686 767 VALIDATE_TITLE PROCEDURE 606 1,228 714 VERY_CONFUSING PROCEDURE 320 486 502

WEBPROC_WITH_PARAM_FORM PROCEDURE 547 472 1,187

49 rows selected. SQL></source>