SYS.DBA_OBJECT_SIZE

The DBA_OBJECT_SIZE view describes the size, in bytes, of PL/SQL objects.

Related views

SYS.USER_OBJECT_SIZE does not display the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2(30) INLINE	Object owner
NAME	VARCHAR2(30) INLINE	Object name
TYPE	VARCHAR2(12) INLINE NOT NULL	Object type (such as PROCEDURE, FUNCTION, PACKAGE)
SOURCE_SIZE	NUMBER NOT NULL	Size of the source in bytes Must be in memory during compilation or dynamic recompilation.
PARSED_SIZE	NUMBER NOT NULL	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 NOT NULL	Code size, in bytes Must be in memory when this object is executing.
ERROR_SIZE	NUMBER NOT NULL	Size of error messages, in bytes Must be in memory during the compilation of the object when there are compilation errors.