Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query user_object_size

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>