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>
| 30.88.user_object_size |
| 30.88.1. | Query user_object_size |