[Home] [Help] [Dependency Information]
Object Name: | CDB_OBJECT_SIZE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Sizes, in bytes, of various pl/sql objects in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Owner of the object | |
NAME | VARCHAR2 | (30) | Name of the object | |
TYPE | VARCHAR2 | (18) | Type of the object: "TYPE", "TYPE BODY", "TABLE", "VIEW", "SYNONYM", "SEQUENCE", "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY", "TRIGGER", "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 | ||
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, NAME
, TYPE
, SOURCE_SIZE
, PARSED_SIZE
, CODE_SIZE
, ERROR_SIZE
, CON_ID
FROM SYS.CDB_OBJECT_SIZE;
SYS.CDB_OBJECT_SIZE does not reference any database object
SYS.CDB_OBJECT_SIZE is referenced by following:
|
|
|