home - keyword index

Keyword: LENGTH

back to index

Columns

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)
top back to index

Comment on this page:




home - keyword index