Column Name
| Description
|
ARRAY_LEN (V$SQL_BIND_METADATA)
|
|
ARRAY_LEN (GV$SQL_BIND_METADATA)
|
|
AVG_COL_LEN (DBA_TAB_COLS)
| The average length of the column in bytes
|
AVG_COL_LEN (USER_SUBPART_COL_STATISTICS)
|
|
AVG_COL_LEN (USER_PART_COL_STATISTICS)
|
|
AVG_COL_LEN (USER_TAB_COL_STATISTICS)
| The average length of the column in bytes
|
AVG_COL_LEN (USER_TAB_COLUMNS)
| The average length of the column in bytes
|
AVG_COL_LEN (DBA_PART_COL_STATISTICS)
|
|
AVG_COL_LEN (COLS)
| The average length of the column in bytes
|
AVG_COL_LEN (USER_TAB_COLS)
| The average length of the column in bytes
|
AVG_COL_LEN (ALL_TAB_COL_STATISTICS)
| The average length of the column in bytes
|
AVG_COL_LEN (ALL_SUBPART_COL_STATISTICS)
|
|
AVG_COL_LEN (ALL_PART_COL_STATISTICS)
|
|
AVG_COL_LEN (ALL_TAB_COLUMNS)
| The average length of the column in bytes
|
AVG_COL_LEN (DBA_TAB_COL_STATISTICS)
| The average length of the column in bytes
|
AVG_COL_LEN (DBA_SUBPART_COL_STATISTICS)
|
|
AVG_COL_LEN (ALL_TAB_COLS)
| The average length of the column in bytes
|
AVG_COL_LEN (DBA_TAB_COLUMNS)
| The average length of the column in bytes
|
AVG_ROW_LEN (ALL_TABLES)
| The average row length, including row overhead
|
AVG_ROW_LEN (DBA_OBJECT_TABLES)
| The average row length, including row overhead
|
AVG_ROW_LEN (TABS)
| The average row length, including row overhead
|
AVG_ROW_LEN (DBA_TABLES)
| The average row length, including row overhead
|
AVG_ROW_LEN (USER_TAB_PARTITIONS)
|
|
AVG_ROW_LEN (DBA_TAB_PARTITIONS)
|
|
AVG_ROW_LEN (DBA_ALL_TABLES)
| The average row length, including row overhead
|
AVG_ROW_LEN (ALL_TAB_PARTITIONS)
|
|
AVG_ROW_LEN (USER_TAB_SUBPARTITIONS)
|
|
AVG_ROW_LEN (ALL_TAB_SUBPARTITIONS)
|
|
AVG_ROW_LEN (DBA_TAB_SUBPARTITIONS)
|
|
AVG_ROW_LEN (USER_OBJECT_TABLES)
| The average row length, including row overhead
|
AVG_ROW_LEN (USER_ALL_TABLES)
| The average row length, including row overhead
|
AVG_ROW_LEN (USER_TABLES)
| The average row length, including row overhead
|
AVG_ROW_LEN (ALL_ALL_TABLES)
| The average row length, including row overhead
|
AVG_ROW_LEN (ALL_OBJECT_TABLES)
| The average row length, including row overhead
|
BUF_LENGTH (V$SQL_BIND_DATA)
|
|
BUF_LENGTH (GV$SQL_BIND_DATA)
|
|
CHAR_COL_DECL_LENGTH (USER_TAB_COLS)
| Declaration length of character type column
|
CHAR_COL_DECL_LENGTH (DBA_TAB_COLUMNS)
| Declaration length of character type column
|
CHAR_COL_DECL_LENGTH (COLS)
| Declaration length of character type column
|
CHAR_COL_DECL_LENGTH (DBA_TAB_COLS)
| Declaration length of character type column
|
CHAR_COL_DECL_LENGTH (ALL_TAB_COLS)
| Declaration length of character type column
|
CHAR_COL_DECL_LENGTH (USER_TAB_COLUMNS)
| Declaration length of character type column
|
CHAR_COL_DECL_LENGTH (ALL_TAB_COLUMNS)
| Declaration length of character type column
|
CHAR_LENGTH (USER_TAB_COLS)
| The maximum length of the column in characters
|
CHAR_LENGTH (USER_ARGUMENTS)
| Character limit for string datatypes
|
CHAR_LENGTH (DBA_TAB_COLUMNS)
| The maximum length of the column in characters
|
CHAR_LENGTH (ALL_ARGUMENTS)
| Character limit for string datatypes
|
CHAR_LENGTH (ALL_REPCOLUMN)
| The maximim length of the column in characters
|
CHAR_LENGTH (USER_TAB_COLUMNS)
| The maximum length of the column in characters
|
CHAR_LENGTH (COLS)
| The maximum length of the column in characters
|
CHAR_LENGTH (ALL_IND_COLUMNS)
| Maximum length of the column or attribute, in characters
|
CHAR_LENGTH (USER_IND_COLUMNS)
| Maximum length of the column or attribute, in characters
|
CHAR_LENGTH (ALL_TAB_COLS)
| The maximum length of the column in characters
|
CHAR_LENGTH (DBA_IND_COLUMNS)
| Maximum length of the column or attribute, in characters
|
CHAR_LENGTH (DBA_REPCOLUMN)
| The maximum length of the column in characters
|
CHAR_LENGTH (DBA_TAB_COLS)
| The maximum length of the column in characters
|
CHAR_LENGTH (USER_REPCOLUMN)
| The maximum length of the column in characters
|
CHAR_LENGTH (ALL_TAB_COLUMNS)
| The maximum length of the column in characters
|
COLUMN_LENGTH (DBA_IND_COLUMNS)
| Maximum length of the column or attribute, in bytes
|
COLUMN_LENGTH (USER_IND_COLUMNS)
| Maximum length of the column or attribute, in bytes
|
COLUMN_LENGTH (ALL_IND_COLUMNS)
| Maximum length of the column or attribute, in bytes
|
DATA_LENGTH (USER_TAB_COLUMNS)
| Length of the column in bytes
|
DATA_LENGTH (DBA_TAB_COLS)
| Length of the column in bytes
|
DATA_LENGTH (ALL_TAB_COLUMNS)
| Length of the column in bytes
|
DATA_LENGTH (USER_SOURCE_TAB_COLUMNS)
|
|
DATA_LENGTH (ALL_TAB_COLS)
| Length of the column in bytes
|
DATA_LENGTH (DBA_REPCOLUMN)
| Length of the column in bytes
|
DATA_LENGTH (USER_REPCOLUMN)
| Length of the column in bytes
|
DATA_LENGTH (ALL_REPAUDIT_ATTRIBUTE)
| Length of the attribute value in byte
|
DATA_LENGTH (USER_PUBLISHED_COLUMNS)
|
|
DATA_LENGTH (USER_REPAUDIT_ATTRIBUTE)
| Length of the attribute value in byte
|
DATA_LENGTH (DBA_SOURCE_TAB_COLUMNS)
|
|
DATA_LENGTH (USER_TAB_COLS)
| Length of the column in bytes
|
DATA_LENGTH (DBA_PUBLISHED_COLUMNS)
|
|
DATA_LENGTH (ALL_SOURCE_TAB_COLUMNS)
|
|
DATA_LENGTH (COLS)
| Length of the column in bytes
|
DATA_LENGTH (DBA_REPAUDIT_ATTRIBUTE)
| Length of the attribute value in byte
|
DATA_LENGTH (ALL_ARGUMENTS)
| Length of the column in bytes
|
DATA_LENGTH (ALL_REPCOLUMN)
| Length of the column in bytes
|
DATA_LENGTH (USER_ARGUMENTS)
| Length of the column in bytes
|
DATA_LENGTH (DBA_TAB_COLUMNS)
| Length of the column in bytes
|
DATA_LENGTH (ALL_PUBLISHED_COLUMNS)
|
|
DEFAULT_LENGTH (USER_ARGUMENTS)
| Length of default value for the argument
|
DEFAULT_LENGTH (USER_TAB_COLS)
| Length of default value for the column
|
DEFAULT_LENGTH (COLS)
| Length of default value for the column
|
DEFAULT_LENGTH (DBA_TAB_COLUMNS)
| Length of default value for the column
|
DEFAULT_LENGTH (USER_TAB_COLUMNS)
| Length of default value for the column
|
DEFAULT_LENGTH (ALL_ARGUMENTS)
| Length of default value for the argument
|
DEFAULT_LENGTH (ALL_TAB_COLUMNS)
| Length of default value for the column
|
DEFAULT_LENGTH (DBA_TAB_COLS)
| Length of default value for the column
|
DEFAULT_LENGTH (ALL_TAB_COLS)
| Length of default value for the column
|
FIXED_DATA_LENGTH (ALL_REPPRIORITY)
| Length of the value in bytes if the datatype is CHAR
|
FIXED_DATA_LENGTH (USER_REPPRIORITY)
| Length of the value in bytes if the datatype is CHAR
|
FIXED_DATA_LENGTH (ALL_REPPRIORITY_GROUP)
| Length of the value in bytes if the datatype is CHAR
|
FIXED_DATA_LENGTH (DBA_REPPRIORITY)
| Length of the value in bytes if the datatype is CHAR
|
FIXED_DATA_LENGTH (USER_REPPRIORITY_GROUP)
| Length of the value in bytes if the datatype is CHAR
|
FIXED_DATA_LENGTH (DBA_REPPRIORITY_GROUP)
| Length of the value in bytes if the datatype is CHAR
|
HIGH_VALUE_LENGTH (DBA_IND_PARTITIONS)
|
|
HIGH_VALUE_LENGTH (ALL_IND_SUBPARTITIONS)
|
|
HIGH_VALUE_LENGTH (DBA_IND_SUBPARTITIONS)
|
|
HIGH_VALUE_LENGTH (USER_IND_PARTITIONS)
|
|
HIGH_VALUE_LENGTH (USER_TAB_PARTITIONS)
|
|
HIGH_VALUE_LENGTH (ALL_IND_PARTITIONS)
|
|
HIGH_VALUE_LENGTH (USER_TAB_SUBPARTITIONS)
|
|
HIGH_VALUE_LENGTH (DBA_TAB_SUBPARTITIONS)
|
|
HIGH_VALUE_LENGTH (USER_IND_SUBPARTITIONS)
|
|
HIGH_VALUE_LENGTH (ALL_TAB_SUBPARTITIONS)
|
|
HIGH_VALUE_LENGTH (DBA_TAB_PARTITIONS)
|
|
HIGH_VALUE_LENGTH (ALL_TAB_PARTITIONS)
|
|
LENGTH (DBA_LMT_USED_EXTENTS)
| Number of blocks in the extent
|
LENGTH (ALL_TYPE_ATTRS)
| Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
|
LENGTH (V$RESERVED_WORDS)
|
|
LENGTH (USER_COLL_TYPES)
| Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
|
LENGTH (ALL_COLL_TYPES)
| Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
|
LENGTH (USER_SQLJ_TYPE_ATTRS)
| Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
|
LENGTH (USER_TYPE_ATTRS)
| Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
|
LENGTH (DBA_COLL_TYPES)
| Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
|
LENGTH (DBA_SQLJ_TYPE_ATTRS)
| Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
|
LENGTH (DBA_DMT_USED_EXTENTS)
| Number of blocks in the extent
|
LENGTH (ALL_SQLJ_TYPE_ATTRS)
| Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
|
LENGTH (DBA_TYPE_ATTRS)
| Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
|
LENGTH (GV$RESERVED_WORDS)
|
|
MAX_LENGTH (GV$SQL_BIND_METADATA)
|
|
MAX_LENGTH (V$SQL_BIND_METADATA)
|
|
OID_TEXT_LENGTH (DBA_VIEWS)
| Length of the WITH OBJECT OID clause of the object view
|
OID_TEXT_LENGTH (USER_VIEWS)
| Length of the WITH OBJECT OID clause of the object view
|
OID_TEXT_LENGTH (ALL_VIEWS)
| Length of the WITH OBJECT OID clause of the object view
|
PREFIX_LENGTH (USER_INDEXES)
| Number of key columns in the prefix used for compression
|
PREFIX_LENGTH (IND)
| Number of key columns in the prefix used for compression
|
PREFIX_LENGTH (ALL_INDEXES)
| Number of key columns in the prefix used for compression
|
PREFIX_LENGTH (DBA_INDEXES)
| Number of key columns in the prefix used for compression
|
PRIVATE_MAX_LEN (V$SQL_BIND_DATA)
|
|
PRIVATE_MAX_LEN (GV$SQL_BIND_DATA)
|
|
QUERY_LEN (USER_MVIEW_ANALYSIS)
| The length (in bytes) of the query field
|
QUERY_LEN (ALL_SUMMARIES)
|
|
QUERY_LEN (DBA_SUMMARIES)
|
|
QUERY_LEN (USER_SUMMARIES)
|
|
QUERY_LEN (DBA_MVIEWS)
| The number of bytes in the defining query (based on the server character set
|
QUERY_LEN (ALL_MVIEWS)
| The number of bytes in the defining query (based on the server character set
|
QUERY_LEN (ALL_MVIEW_ANALYSIS)
| The length (in bytes) of the query field
|
QUERY_LEN (USER_MVIEWS)
| The number of bytes in the defining query (based on the server character set
|
QUERY_LEN (DBA_MVIEW_ANALYSIS)
| The length (in bytes) of the query field
|
QUEUE_LENGTH (V$RSRC_CONSUMER_GROUP)
|
|
QUEUE_LENGTH (GV$RSRC_CONSUMER_GROUP)
|
|
REDO_LENGTH (V$LOGMNR_CONTENTS)
|
|
REDO_LENGTH (GV$LOGMNR_CONTENTS)
|
|
SHARED_MAX_LEN (GV$SQL_BIND_DATA)
|
|
SHARED_MAX_LEN (V$SQL_BIND_DATA)
|
|
SND_Q_LEN (V$DLM_TRAFFIC_CONTROLLER)
|
|
SND_Q_LEN (GV$DLM_TRAFFIC_CONTROLLER)
|
|
TEXT_LENGTH (ALL_VIEWS)
| Length of the view text
|
TEXT_LENGTH (USER_VIEWS)
| Length of the view text
|
TEXT_LENGTH (DBA_VIEWS)
| Length of the view text
|
TYPE_TEXT_LENGTH (ALL_VIEWS)
| Length of the type clause of the object view
|
TYPE_TEXT_LENGTH (DBA_VIEWS)
| Length of the type clause of the object view
|
TYPE_TEXT_LENGTH (USER_VIEWS)
| Length of the type clause of the object view
|
UNDO_LENGTH (GV$LOGMNR_CONTENTS)
|
|
UNDO_LENGTH (V$LOGMNR_CONTENTS)
|
|
VAL_LENGTH (V$SQL_BIND_DATA)
|
|
VAL_LENGTH (GV$SQL_BIND_DATA)
|
|