DBA_OBJECT_SIZE

Sizes,in bytes,of various pl/sql objects
Columns
   ___________________________
 
   OWNER
      Owner of the object
   NAME
      Name of the object
   TYPE
      "Type of the object: "TYPE","TYPE
   SOURCE_SIZE
      Size of the source,in bytes. Must be in memory during compilation or dynamic recompilation
   PARSED_SIZE
      Size of the parsed form of the object,in bytes. Must be in memory whenan object is being compiled that references this object
   CODE_SIZE
      Code size,in bytes. Must be in memory when this object is executing
   ERROR_SIZE
      Size of error messages,in bytes. In memory during the compilation of the object when there are compilation errors