Keyword: EXTENT
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| DBA_DMT_USED_EXTENTS | All extents in the dictionary managed tablespaces |
| DBA_EXTENTS | Extents comprising all segments in the database |
| DBA_LMT_USED_EXTENTS | All extents in the locally managed tablespaces |
| DBA_UNDO_EXTENTS | Extents comprising all segments in the system managed undo tablespaces |
| GV$MAP_FILE_EXTENT | Synonym for GV_$MAP_FILE_EXTENT |
| GV$TEMP_EXTENT_MAP | Synonym for GV_$TEMP_EXTENT_MAP |
| GV$TEMP_EXTENT_POOL | Synonym for GV_$TEMP_EXTENT_POOL |
| USER_EXTENTS | Extents comprising segments owned by the user |
| V$MAP_FILE_EXTENT | Synonym for V_$MAP_FILE_EXTENT |
| V$TEMP_EXTENT_MAP | Synonym for V_$TEMP_EXTENT_MAP |
| V$TEMP_EXTENT_POOL | Synonym for V_$TEMP_EXTENT_POOL |
Columns
| Column Name | Description |
|---|---|
| ADDED_EXTENTS (V$SORT_SEGMENT) | |
| ADDED_EXTENTS (GV$SORT_SEGMENT) | |
| DEF_INITIAL_EXTENT (ALL_PART_INDEXES) | |
| DEF_INITIAL_EXTENT (DBA_PART_LOBS) | |
| DEF_INITIAL_EXTENT (USER_PART_LOBS) | |
| DEF_INITIAL_EXTENT (ALL_PART_LOBS) | |
| DEF_INITIAL_EXTENT (ALL_PART_TABLES) | |
| DEF_INITIAL_EXTENT (DBA_PART_TABLES) | |
| DEF_INITIAL_EXTENT (USER_PART_TABLES) | |
| DEF_INITIAL_EXTENT (USER_PART_INDEXES) | |
| DEF_INITIAL_EXTENT (DBA_PART_INDEXES) | |
| DEF_MAX_EXTENTS (USER_PART_TABLES) | |
| DEF_MAX_EXTENTS (USER_PART_LOBS) | |
| DEF_MAX_EXTENTS (DBA_PART_TABLES) | |
| DEF_MAX_EXTENTS (DBA_PART_INDEXES) | |
| DEF_MAX_EXTENTS (USER_PART_INDEXES) | |
| DEF_MAX_EXTENTS (DBA_PART_LOBS) | |
| DEF_MAX_EXTENTS (ALL_PART_INDEXES) | |
| DEF_MAX_EXTENTS (ALL_PART_TABLES) | |
| DEF_MAX_EXTENTS (ALL_PART_LOBS) | |
| DEF_MIN_EXTENTS (DBA_PART_TABLES) | |
| DEF_MIN_EXTENTS (DBA_PART_LOBS) | |
| DEF_MIN_EXTENTS (ALL_PART_INDEXES) | |
| DEF_MIN_EXTENTS (ALL_PART_LOBS) | |
| DEF_MIN_EXTENTS (DBA_PART_INDEXES) | |
| DEF_MIN_EXTENTS (USER_PART_LOBS) | |
| DEF_MIN_EXTENTS (USER_PART_INDEXES) | |
| DEF_MIN_EXTENTS (ALL_PART_TABLES) | |
| DEF_MIN_EXTENTS (USER_PART_TABLES) | |
| DEF_NEXT_EXTENT (DBA_PART_TABLES) | |
| DEF_NEXT_EXTENT (ALL_PART_TABLES) | |
| DEF_NEXT_EXTENT (ALL_PART_INDEXES) | |
| DEF_NEXT_EXTENT (DBA_PART_INDEXES) | |
| DEF_NEXT_EXTENT (USER_PART_INDEXES) | |
| DEF_NEXT_EXTENT (ALL_PART_LOBS) | |
| DEF_NEXT_EXTENT (USER_PART_TABLES) | |
| DEF_NEXT_EXTENT (USER_PART_LOBS) | |
| DEF_NEXT_EXTENT (DBA_PART_LOBS) | |
| EXTENTS (USER_SEGMENTS) | Number of extents allocated to the segment |
| EXTENTS (V$ROLLSTAT) | |
| EXTENTS (DBA_SEGMENTS) | Number of extents allocated to the segment |
| EXTENTS (GV$TEMPSEG_USAGE) | |
| EXTENTS (GV$SORT_USAGE) | |
| EXTENTS (V$TEMPSEG_USAGE) | |
| EXTENTS (GV$ROLLSTAT) | |
| EXTENTS (V$SORT_USAGE) | |
| EXTENTS_CACHED (V$TEMP_EXTENT_POOL) | |
| EXTENTS_CACHED (GV$TEMP_EXTENT_POOL) | |
| EXTENTS_COALESCED (DBA_FREE_SPACE_COALESCED_TMP1) | Number of Coalesced Free Extents in Tablespace |
| EXTENTS_COALESCED (DBA_FREE_SPACE_COALESCED) | Total Number of Coalesced Free Extents in Tablespace |
| EXTENTS_USED (V$TEMP_EXTENT_POOL) | |
| EXTENTS_USED (GV$TEMP_EXTENT_POOL) | |
| EXTENT_HITS (GV$SORT_SEGMENT) | |
| EXTENT_HITS (V$SORT_SEGMENT) | |
| EXTENT_ID (DBA_EXTENTS) | Extent number in the segment |
| EXTENT_ID (USER_EXTENTS) | Extent number in the segment |
| EXTENT_ID (DBA_LMT_USED_EXTENTS) | Extent number in the segment |
| EXTENT_ID (DBA_DMT_USED_EXTENTS) | Extent number in the segment |
| EXTENT_ID (DBA_UNDO_EXTENTS) | Extent number in the segment |
| EXTENT_MANAGEMENT (USER_TABLESPACES) | Extent management tracking: "DICTIONARY" or "LOCAL" |
| EXTENT_MANAGEMENT (DBA_TABLESPACES) | Extent management tracking: "DICTIONARY" or "LOCAL" |
| EXTENT_SIZE (GV$SORT_SEGMENT) | |
| EXTENT_SIZE (V$SORT_SEGMENT) | |
| FREED_EXTENTS (V$SORT_SEGMENT) | |
| FREED_EXTENTS (GV$SORT_SEGMENT) | |
| FREE_EXTENTS (GV$SORT_SEGMENT) | |
| FREE_EXTENTS (V$SORT_SEGMENT) | |
| INITIAL_EXTENT (DBA_IND_SUBPARTITIONS) | |
| INITIAL_EXTENT (DBA_IND_PARTITIONS) | |
| INITIAL_EXTENT (ALL_CLUSTERS) | Size of the initial extent in bytes |
| INITIAL_EXTENT (DBA_CLUSTERS) | Size of the initial extent in bytes |
| INITIAL_EXTENT (USER_TAB_SUBPARTITIONS) | |
| INITIAL_EXTENT (DBA_TABLESPACES) | Default initial extent size |
| INITIAL_EXTENT (ALL_OBJECT_TABLES) | Size of the initial extent in bytes |
| INITIAL_EXTENT (USER_LOB_SUBPARTITIONS) | |
| INITIAL_EXTENT (DBA_TAB_SUBPARTITIONS) | |
| INITIAL_EXTENT (DBA_OBJECT_TABLES) | Size of the initial extent in bytes |
| INITIAL_EXTENT (DBA_TAB_PARTITIONS) | |
| INITIAL_EXTENT (USER_TAB_PARTITIONS) | |
| INITIAL_EXTENT (USER_TABLESPACES) | Default initial extent size |
| INITIAL_EXTENT (USER_OBJECT_TABLES) | Size of the initial extent in bytes |
| INITIAL_EXTENT (ALL_INDEXES) | Size of the initial extent |
| INITIAL_EXTENT (USER_IND_SUBPARTITIONS) | |
| INITIAL_EXTENT (ALL_LOB_SUBPARTITIONS) | |
| INITIAL_EXTENT (USER_TABLES) | Size of the initial extent in bytes |
| INITIAL_EXTENT (IND) | Size of the initial extent in bytes |
| INITIAL_EXTENT (USER_LOB_PARTITIONS) | |
| INITIAL_EXTENT (ALL_IND_PARTITIONS) | |
| INITIAL_EXTENT (USER_INDEXES) | Size of the initial extent in bytes |
| INITIAL_EXTENT (USER_CLUSTERS) | Size of the initial extent in bytes |
| INITIAL_EXTENT (CLU) | Size of the initial extent in bytes |
| INITIAL_EXTENT (USER_ALL_TABLES) | Size of the initial extent in bytes |
| INITIAL_EXTENT (DBA_ALL_TABLES) | Size of the initial extent in bytes |
| INITIAL_EXTENT (DBA_INDEXES) | Size of the initial extent |
| INITIAL_EXTENT (ALL_TAB_PARTITIONS) | |
| INITIAL_EXTENT (USER_IND_PARTITIONS) | |
| INITIAL_EXTENT (ALL_IND_SUBPARTITIONS) | |
| INITIAL_EXTENT (ALL_TABLES) | Size of the initial extent in bytes |
| INITIAL_EXTENT (DBA_TABLES) | Size of the initial extent in bytes |
| INITIAL_EXTENT (DBA_LOB_PARTITIONS) | |
| INITIAL_EXTENT (ALL_TAB_SUBPARTITIONS) | |
| INITIAL_EXTENT (USER_SEGMENTS) | Size, in bytes, of the initial extent of the segment |
| INITIAL_EXTENT (ALL_LOB_PARTITIONS) | |
| INITIAL_EXTENT (DBA_ROLLBACK_SEGS) | Initial extent size in bytes |
| INITIAL_EXTENT (DBA_SEGMENTS) | Size, in bytes, of the initial extent of the segment |
| INITIAL_EXTENT (TABS) | Size of the initial extent in bytes |
| INITIAL_EXTENT (DBA_LOB_SUBPARTITIONS) | |
| INITIAL_EXTENT (ALL_ALL_TABLES) | Size of the initial extent in bytes |
| MAX_EXTENT (USER_IND_PARTITIONS) | |
| MAX_EXTENT (ALL_TAB_SUBPARTITIONS) | |
| MAX_EXTENT (DBA_IND_PARTITIONS) | |
| MAX_EXTENT (DBA_TAB_SUBPARTITIONS) | |
| MAX_EXTENT (DBA_TAB_PARTITIONS) | |
| MAX_EXTENT (ALL_IND_SUBPARTITIONS) | |
| MAX_EXTENT (USER_IND_SUBPARTITIONS) | |
| MAX_EXTENT (DBA_IND_SUBPARTITIONS) | |
| MAX_EXTENT (ALL_TAB_PARTITIONS) | |
| MAX_EXTENT (ALL_IND_PARTITIONS) | |
| MAX_EXTENT (USER_TAB_PARTITIONS) | |
| MAX_EXTENT (USER_TAB_SUBPARTITIONS) | |
| MAX_EXTENTS (ALL_LOB_PARTITIONS) | |
| MAX_EXTENTS (DBA_ROLLBACK_SEGS) | Maximum number of extents |
| MAX_EXTENTS (USER_LOB_PARTITIONS) | |
| MAX_EXTENTS (USER_ALL_TABLES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (USER_INDEXES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (USER_SEGMENTS) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (DBA_INDEXES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (USER_TABLES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (ALL_TABLES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (DBA_LOB_PARTITIONS) | |
| MAX_EXTENTS (DBA_OBJECT_TABLES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (DBA_SEGMENTS) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (USER_CLUSTERS) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (USER_OBJECT_TABLES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (DBA_TABLES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (ALL_ALL_TABLES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (USER_TABLESPACES) | Default maximum number of extents |
| MAX_EXTENTS (DBA_LOB_SUBPARTITIONS) | |
| MAX_EXTENTS (DBA_TABLESPACES) | Default maximum number of extents |
| MAX_EXTENTS (IND) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (ALL_INDEXES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (CLU) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (ALL_CLUSTERS) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (ALL_OBJECT_TABLES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (TABS) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (USER_LOB_SUBPARTITIONS) | |
| MAX_EXTENTS (DBA_CLUSTERS) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (DBA_ALL_TABLES) | Maximum number of extents allowed in the segment |
| MAX_EXTENTS (ALL_LOB_SUBPARTITIONS) | |
| MIN_EXTENT (DBA_IND_PARTITIONS) | |
| MIN_EXTENT (ALL_IND_SUBPARTITIONS) | |
| MIN_EXTENT (USER_TAB_SUBPARTITIONS) | |
| MIN_EXTENT (ALL_TAB_SUBPARTITIONS) | |
| MIN_EXTENT (USER_IND_PARTITIONS) | |
| MIN_EXTENT (USER_TAB_PARTITIONS) | |
| MIN_EXTENT (USER_IND_SUBPARTITIONS) | |
| MIN_EXTENT (DBA_IND_SUBPARTITIONS) | |
| MIN_EXTENT (ALL_IND_PARTITIONS) | |
| MIN_EXTENT (DBA_TAB_PARTITIONS) | |
| MIN_EXTENT (DBA_TAB_SUBPARTITIONS) | |
| MIN_EXTENT (ALL_TAB_PARTITIONS) | |
| MIN_EXTENTS (ALL_ALL_TABLES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (IND) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (DBA_TABLESPACES) | Default minimum number of extents |
| MIN_EXTENTS (ALL_CLUSTERS) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (ALL_INDEXES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (DBA_OBJECT_TABLES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (DBA_INDEXES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (USER_OBJECT_TABLES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (CLU) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (USER_LOB_SUBPARTITIONS) | |
| MIN_EXTENTS (DBA_ALL_TABLES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (USER_INDEXES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (USER_ALL_TABLES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (ALL_TABLES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (ALL_OBJECT_TABLES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (USER_LOB_PARTITIONS) | |
| MIN_EXTENTS (DBA_LOB_PARTITIONS) | |
| MIN_EXTENTS (USER_TABLES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (ALL_LOB_PARTITIONS) | |
| MIN_EXTENTS (DBA_TABLES) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (DBA_SEGMENTS) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (USER_CLUSTERS) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (USER_SEGMENTS) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (ALL_LOB_SUBPARTITIONS) | |
| MIN_EXTENTS (DBA_CLUSTERS) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (DBA_ROLLBACK_SEGS) | Minimum number of extents |
| MIN_EXTENTS (DBA_LOB_SUBPARTITIONS) | |
| MIN_EXTENTS (TABS) | Minimum number of extents allowed in the segment |
| MIN_EXTENTS (USER_TABLESPACES) | Default minimum number of extents |
| NEXT_EXTENT (ALL_ALL_TABLES) | Size of secondary extents in bytes |
| NEXT_EXTENT (ALL_IND_SUBPARTITIONS) | |
| NEXT_EXTENT (TABS) | Size of secondary extents in bytes |
| NEXT_EXTENT (USER_CLUSTERS) | Size of secondary extents in bytes |
| NEXT_EXTENT (USER_LOB_PARTITIONS) | |
| NEXT_EXTENT (DBA_TABLES) | Size of secondary extents in bytes |
| NEXT_EXTENT (USER_TABLES) | Size of secondary extents in bytes |
| NEXT_EXTENT (DBA_LOB_SUBPARTITIONS) | |
| NEXT_EXTENT (USER_IND_PARTITIONS) | |
| NEXT_EXTENT (DBA_ROLLBACK_SEGS) | Secondary extent size in bytes |
| NEXT_EXTENT (USER_OBJECT_TABLES) | Size of secondary extents in bytes |
| NEXT_EXTENT (ALL_TAB_PARTITIONS) | |
| NEXT_EXTENT (USER_TAB_PARTITIONS) | |
| NEXT_EXTENT (DBA_OBJECT_TABLES) | Size of secondary extents in bytes |
| NEXT_EXTENT (USER_INDEXES) | Size of secondary extents in bytes |
| NEXT_EXTENT (DBA_TAB_SUBPARTITIONS) | |
| NEXT_EXTENT (ALL_CLUSTERS) | Size of secondary extents in bytes |
| NEXT_EXTENT (IND) | Size of secondary extents in bytes |
| NEXT_EXTENT (ALL_TAB_SUBPARTITIONS) | |
| NEXT_EXTENT (USER_SEGMENTS) | Size, in bytes, of the next extent to be allocated to the segment |
| NEXT_EXTENT (USER_TABLESPACES) | Default incremental extent size |
| NEXT_EXTENT (USER_LOB_SUBPARTITIONS) | |
| NEXT_EXTENT (CLU) | Size of secondary extents in bytes |
| NEXT_EXTENT (DBA_IND_PARTITIONS) | |
| NEXT_EXTENT (DBA_LOB_PARTITIONS) | |
| NEXT_EXTENT (USER_TAB_SUBPARTITIONS) | |
| NEXT_EXTENT (ALL_INDEXES) | Size of secondary extents |
| NEXT_EXTENT (ALL_OBJECT_TABLES) | Size of secondary extents in bytes |
| NEXT_EXTENT (DBA_TABLESPACES) | Default incremental extent size |
| NEXT_EXTENT (ALL_LOB_SUBPARTITIONS) | |
| NEXT_EXTENT (USER_IND_SUBPARTITIONS) | |
| NEXT_EXTENT (DBA_TAB_PARTITIONS) | |
| NEXT_EXTENT (ALL_IND_PARTITIONS) | |
| NEXT_EXTENT (DBA_SEGMENTS) | Size, in bytes, of the next extent to be allocated to the segment |
| NEXT_EXTENT (DBA_INDEXES) | Size of secondary extents |
| NEXT_EXTENT (DBA_IND_SUBPARTITIONS) | |
| NEXT_EXTENT (DBA_ALL_TABLES) | Size of secondary extents in bytes |
| NEXT_EXTENT (ALL_LOB_PARTITIONS) | |
| NEXT_EXTENT (USER_ALL_TABLES) | Size of secondary extents in bytes |
| NEXT_EXTENT (ALL_TABLES) | Size of secondary extents in bytes |
| NEXT_EXTENT (DBA_CLUSTERS) | Size of secondary extents in bytes |
| PERCENT_EXTENTS_COALESCED (DBA_FREE_SPACE_COALESCED) | Percentage of Coalesced Free Extents in Tablespace |
| TOTAL_EXTENTS (V$SORT_SEGMENT) | |
| TOTAL_EXTENTS (DBA_FREE_SPACE_COALESCED_TMP2) | Number of Free Extents in Tablespace |
| TOTAL_EXTENTS (DBA_FREE_SPACE_COALESCED_TMP3) | Number of Free Extents in Tablespace |
| TOTAL_EXTENTS (DBA_FREE_SPACE_COALESCED) | Total Number of Free Extents in Tablespace |
| TOTAL_EXTENTS (GV$SORT_SEGMENT) | |
| USED_EXTENTS (GV$SORT_SEGMENT) | |
| USED_EXTENTS (V$SORT_SEGMENT) |