[Home] [Help] [Dependency Information]
Object Name: | USER_OBJECT_SIZE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Sizes, in bytes, of various pl/sql objects
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (128) | 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", "JAVA RESOURCE", "JAVA DATA" "CUBE DIMENSION", "CUBE", "MEASURE FOLDER", or "CUBE BUILD PROCESS" | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, TYPE
, SOURCE_SIZE
, PARSED_SIZE
, CODE_SIZE
, ERROR_SIZE
FROM SYS.USER_OBJECT_SIZE;
|
|
|