DBA_OBJECT

DBA_OBJECT_SIZE

Sizes, in bytes, of various pl/sql objects

Columns
   ___________________________
 
   PARSED_SIZE
      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
      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
   TYPE
      Type of the object: `TYPE`, `TYPE BODY`, `TABLE`, `VIEW`, `SYNONYM`, `SEQUENCE`, `PROCEDURE`, `FUNCTION`, `PACKAGE`, `PACKAGE BODY`, `JAVA SOURCE`, `JAVA CLASS`, `JAVA RESOURCE` or `JAVA DATA`
   NAME
      Name of the object
   OWNER
      Owner of the object
   SOURCE_SIZE
      Size of the source, in bytes.  Must be in memory during compilation, or dynamic recompilation

Related Commands:

Simon Sheppard
SS64.com