DBA_OBJECT_SIZE
DBA_OBJECT_SIZE lists the sizes, in bytes, of various PL/SQL objects.
Related View
USER_OBJECT_SIZElists the size of PL/SQL objects owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the object |
NAME |
VARCHAR2(128) |
NOT NULL |
Name of the object |
TYPE |
VARCHAR2(18) |
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. |
See Also: “USER_OBJECT_SIZE”