SYS.DBA_OBJECT_SIZE

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

Related views

USER_OBJECT_SIZE describes the size, in bytes, of PL/SQL objects owned by the current user. This view does not display the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2 (30) NOT NULL	Object owner.
NAME	VARCHAR2 (30) NOT NULL	Object name.
TYPE	VARCHAR2 (12) NOT NULL	Object type (such as PROCEDURE, FUNCTION, PACKAGE).
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 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.