Keyword: KEY
jump to Columns back to indexTables
Table Name | Description |
---|---|
ALL_APPLY_KEY_COLUMNS | Alternative key columns for a STREAMS table visible to the current user |
ALL_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
ALL_DIM_LEVEL_KEY | Representations of columns of a dimension level |
ALL_MVIEW_KEYS | Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user |
ALL_PART_KEY_COLUMNS | |
ALL_SUBPART_KEY_COLUMNS | |
ALL_SUMMARY_KEYS | |
DBA_APPLY_KEY_COLUMNS | alternative key columns for a table for STREAMS |
DBA_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
DBA_DIM_LEVEL_KEY | Representations of columns of a dimension level |
DBA_MVIEW_KEYS | Description of the columns that appear in the GROUP BY list of a materialized view accessible to dba |
DBA_PART_KEY_COLUMNS | |
DBA_SUBPART_KEY_COLUMNS | |
DBA_SUMMARY_KEYS | |
USER_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
USER_DIM_LEVEL_KEY | Representations of columns of a dimension level |
USER_MVIEW_KEYS | Description of the columns that appear in the GROUP BY list of a materialized view created by the user |
USER_PART_KEY_COLUMNS | |
USER_SUBPART_KEY_COLUMNS | |
USER_SUMMARY_KEYS |
Columns
Column Name | Description |
---|---|
AVG_BLOCKS_PER_KEY (USER_CLUSTERS) | Average number of blocks containing rows with a given cluster key |
AVG_BLOCKS_PER_KEY (ALL_CLUSTERS) | Average number of blocks containing rows with a given cluster key |
AVG_BLOCKS_PER_KEY (CLU) | Average number of blocks containing rows with a given cluster key |
AVG_BLOCKS_PER_KEY (DBA_CLUSTERS) | Average number of blocks containing rows with a given cluster key |
AVG_DATA_BLOCKS_PER_KEY (USER_INDEXES) | The average number of data blocks per key |
AVG_DATA_BLOCKS_PER_KEY (DBA_INDEXES) | The average number of data blocks per key |
AVG_DATA_BLOCKS_PER_KEY (IND) | The average number of data blocks per key |
AVG_DATA_BLOCKS_PER_KEY (DBA_IND_SUBPARTITIONS) | |
AVG_DATA_BLOCKS_PER_KEY (ALL_IND_PARTITIONS) | |
AVG_DATA_BLOCKS_PER_KEY (USER_IND_PARTITIONS) | |
AVG_DATA_BLOCKS_PER_KEY (DBA_IND_PARTITIONS) | |
AVG_DATA_BLOCKS_PER_KEY (ALL_INDEXES) | The average number of data blocks per key |
AVG_DATA_BLOCKS_PER_KEY (ALL_IND_SUBPARTITIONS) | |
AVG_DATA_BLOCKS_PER_KEY (USER_IND_SUBPARTITIONS) | |
AVG_LEAF_BLOCKS_PER_KEY (ALL_INDEXES) | The average number of leaf blocks per key |
AVG_LEAF_BLOCKS_PER_KEY (DBA_IND_SUBPARTITIONS) | |
AVG_LEAF_BLOCKS_PER_KEY (DBA_INDEXES) | The average number of leaf blocks per key |
AVG_LEAF_BLOCKS_PER_KEY (USER_IND_SUBPARTITIONS) | |
AVG_LEAF_BLOCKS_PER_KEY (USER_INDEXES) | The average number of leaf blocks per key |
AVG_LEAF_BLOCKS_PER_KEY (IND) | The average number of leaf blocks per key |
AVG_LEAF_BLOCKS_PER_KEY (USER_IND_PARTITIONS) | |
AVG_LEAF_BLOCKS_PER_KEY (ALL_IND_SUBPARTITIONS) | |
AVG_LEAF_BLOCKS_PER_KEY (DBA_IND_PARTITIONS) | |
AVG_LEAF_BLOCKS_PER_KEY (ALL_IND_PARTITIONS) | |
DIM_KEY_ID (ALL_DIM_JOIN_KEY) | Join key ID (unique within a dimension) |
DIM_KEY_ID (DBA_DIM_JOIN_KEY) | Join key ID (unique within a dimension) |
DIM_KEY_ID (USER_DIM_JOIN_KEY) | Join key ID (unique within a dimension) |
DISTINCT_KEYS (USER_INDEXES) | The number of distinct keys in the index |
DISTINCT_KEYS (USER_IND_PARTITIONS) | |
DISTINCT_KEYS (ALL_IND_SUBPARTITIONS) | |
DISTINCT_KEYS (ALL_IND_PARTITIONS) | |
DISTINCT_KEYS (DBA_IND_PARTITIONS) | |
DISTINCT_KEYS (DBA_INDEXES) | The number of distinct keys in the index |
DISTINCT_KEYS (ALL_INDEXES) | The number of distinct keys in the index |
DISTINCT_KEYS (DBA_IND_SUBPARTITIONS) | |
DISTINCT_KEYS (IND) | The number of distinct keys in the index |
DISTINCT_KEYS (USER_IND_SUBPARTITIONS) | |
JOIN_KEY_ID (ALL_DIM_CHILD_OF) | Keys that join child uniquely to the parent |
JOIN_KEY_ID (DBA_DIM_CHILD_OF) | Keys that join child uniquely to the parent |
JOIN_KEY_ID (USER_DIM_CHILD_OF) | Keys that join child uniquely to the parent |
KEY (V$ROWCACHE_PARENT) | |
KEY (GV$ROWCACHE_PARENT) | |
KEY (GV$ROWCACHE_SUBORDINATE) | |
KEY (V$ROWCACHE_SUBORDINATE) | |
KEY_POSITION (ALL_DIM_LEVEL_KEY) | Ordinal position of the key column within the level |
KEY_POSITION (DBA_DIM_LEVEL_KEY) | Ordinal position of the key column within the level |
KEY_POSITION (ALL_DIM_JOIN_KEY) | Position of the key column within the level |
KEY_POSITION (USER_DIM_JOIN_KEY) | Position of the key column within the level |
KEY_POSITION (USER_DIM_LEVEL_KEY) | Ordinal position of the key column within the level |
KEY_POSITION (DBA_DIM_JOIN_KEY) | Position of the key column within the level |
KEY_SIZE (ALL_CLUSTERS) | Estimated size of cluster key plus associated rows |
KEY_SIZE (CLU) | Estimated size of cluster key plus associated rows |
KEY_SIZE (DBA_CLUSTERS) | Estimated size of cluster key plus associated rows |
KEY_SIZE (USER_CLUSTERS) | Estimated size of cluster key plus associated rows |
PARTITIONING_KEY_COUNT (ALL_PART_INDEXES) | |
PARTITIONING_KEY_COUNT (USER_PART_TABLES) | |
PARTITIONING_KEY_COUNT (DBA_PART_TABLES) | |
PARTITIONING_KEY_COUNT (DBA_PART_INDEXES) | |
PARTITIONING_KEY_COUNT (USER_PART_INDEXES) | |
PARTITIONING_KEY_COUNT (ALL_PART_TABLES) | |
PRIMARY_KEY (ALL_MVIEW_LOGS) | If YES, the materialized view log records primary key information |
PRIMARY_KEY (USER_SNAPSHOT_LOGS) | If YES, the snapshot log records primary key information |
PRIMARY_KEY (DBA_MVIEW_LOGS) | If YES, the materialized view log records primary key information |
PRIMARY_KEY (DBA_SNAPSHOT_LOGS) | If YES, the snapshot log records primary key information |
PRIMARY_KEY (ALL_SNAPSHOT_LOGS) | If YES, the snapshot log records primary key information |
PRIMARY_KEY (USER_MVIEW_LOGS) | If YES, the materialized view log records primary key information |
PRIMARY_KEY_VALUE (ALL_REPRESOLUTION_STATISTICS) | Primary key of the replicated row (character data) |
PRIMARY_KEY_VALUE (USER_REPRESOLUTION_STATISTICS) | Primary key of the replicated row (character data) |
PRIMARY_KEY_VALUE (DBA_REPRESOLUTION_STATISTICS) | Primary key of the replicated row (character data) |
SUBPARTITIONING_KEY_COUNT (USER_PART_TABLES) | |
SUBPARTITIONING_KEY_COUNT (ALL_PART_INDEXES) | |
SUBPARTITIONING_KEY_COUNT (ALL_PART_TABLES) | |
SUBPARTITIONING_KEY_COUNT (DBA_PART_INDEXES) | |
SUBPARTITIONING_KEY_COUNT (USER_PART_INDEXES) | |
SUBPARTITIONING_KEY_COUNT (DBA_PART_TABLES) |