Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
DBA_OBJECT_SIZE
lists the sizes, in bytes, of various PL/SQL objects.
Related View
USER_OBJECT_SIZE
lists the size of PL/SQL objects owned by the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object |
NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object |
TYPE |
VARCHAR2(12) |
Type of the object: TYPE, TYPE BODY, TABLE, VIEW, SYNONYM, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, JAVA SOURCE, JAVA CLASS or JAVA RESOURCE |
|
SOURCE_SIZE |
NUMBER |
Size of the source in bytes. Must be in memory during compilation, or dynamic recompilation. | |
PARSED_SIZE |
NUMBER |
Size of the parsed form of the object, in bytes. Must be in memory when an object is being compiled that references this object. | |
CODE_SIZE |
NUMBER |
Code size, in bytes. Must be in memory when this object is executing. | |
ERROR_SIZE |
NUMBER |
Size of error messages, in bytes. In memory during the compilation of the object when there are compilation errors. |