Query user_object_size table : user_object_size « System Tables Views « Oracle PL / SQL

Home
Oracle PL / SQL
1.Aggregate Functions
2.Analytical Functions
3.Char Functions
4.Constraints
5.Conversion Functions
6.Cursor
7.Data Type
8.Date Timezone
9.Hierarchical Query
10.Index
11.Insert Delete Update
12.Large Objects
13.Numeric Math Functions
14.Object Oriented Database
15.PL SQL
16.Regular Expressions
17.Report Column Page
18.Result Set
19.Select Query
20.Sequence
21.SQL Plus
22.Stored Procedure Function
23.Subquery
24.System Packages
25.System Tables Views
26.Table
27.Table Joins
28.Trigger
29.User Previliege
30.View
31.XML
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>

 
Related examples in the same category
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.