Keyword: SPACE
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| DBA_DMT_FREE_SPACE | Free extents in all dictionary managed tablespaces |
| DBA_FREE_SPACE | Free extents in all tablespaces |
| DBA_FREE_SPACE_COALESCED | Statistics on Coalesced Space in Tablespaces |
| DBA_FREE_SPACE_COALESCED_TMP1 | |
| DBA_FREE_SPACE_COALESCED_TMP2 | |
| DBA_FREE_SPACE_COALESCED_TMP3 | |
| DBA_LMT_FREE_SPACE | Free extents in all locally managed tablespaces |
| GV$TEMP_SPACE_HEADER | Synonym for GV_$TEMP_SPACE_HEADER |
| USER_FREE_SPACE | Free extents in tablespaces accessible to the user |
| V$TEMP_SPACE_HEADER | Synonym for V_$TEMP_SPACE_HEADER |
Columns
| Column Name | Description |
|---|---|
| AVG_SPACE (ALL_OBJECT_TABLES) | The average available free space in the table |
| AVG_SPACE (DBA_TABLES) | The average available free space in the table |
| AVG_SPACE (USER_TAB_SUBPARTITIONS) | |
| AVG_SPACE (TABS) | The average available free space in the table |
| AVG_SPACE (ALL_TABLES) | The average available free space in the table |
| AVG_SPACE (ALL_TAB_PARTITIONS) | |
| AVG_SPACE (ALL_TAB_SUBPARTITIONS) | |
| AVG_SPACE (DBA_OBJECT_TABLES) | The average available free space in the table |
| AVG_SPACE (ALL_ALL_TABLES) | The average available free space in the table |
| AVG_SPACE (USER_OBJECT_TABLES) | The average available free space in the table |
| AVG_SPACE (DBA_ALL_TABLES) | The average available free space in the table |
| AVG_SPACE (DBA_TAB_SUBPARTITIONS) | |
| AVG_SPACE (USER_TAB_PARTITIONS) | |
| AVG_SPACE (USER_TABLES) | The average available free space in the table |
| AVG_SPACE (USER_ALL_TABLES) | The average available free space in the table |
| AVG_SPACE (DBA_TAB_PARTITIONS) | |
| AVG_SPACE_FREELIST_BLOCKS (USER_ALL_TABLES) | The average freespace of all blocks on a freelist |
| AVG_SPACE_FREELIST_BLOCKS (USER_TABLES) | The average freespace of all blocks on a freelist |
| AVG_SPACE_FREELIST_BLOCKS (DBA_OBJECT_TABLES) | The average freespace of all blocks on a freelist |
| AVG_SPACE_FREELIST_BLOCKS (ALL_OBJECT_TABLES) | The average freespace of all blocks on a freelist |
| AVG_SPACE_FREELIST_BLOCKS (ALL_TABLES) | The average freespace of all blocks on a freelist |
| AVG_SPACE_FREELIST_BLOCKS (DBA_TABLES) | The average freespace of all blocks on a freelist |
| AVG_SPACE_FREELIST_BLOCKS (DBA_ALL_TABLES) | The average freespace of all blocks on a freelist |
| AVG_SPACE_FREELIST_BLOCKS (ALL_ALL_TABLES) | The average freespace of all blocks on a freelist |
| AVG_SPACE_FREELIST_BLOCKS (TABS) | The average freespace of all blocks on a freelist |
| AVG_SPACE_FREELIST_BLOCKS (USER_OBJECT_TABLES) | The average freespace of all blocks on a freelist |
| FREE_SPACE (GV$SHARED_POOL_RESERVED) | |
| FREE_SPACE (V$SHARED_POOL_RESERVED) | |
| NAME_SPACE (V$ARCHIVE_DEST) | |
| NAME_SPACE (GV$ARCHIVE_DEST) | |
| SEGMENT_SPACE_MANAGEMENT (USER_TABLESPACES) | Segment space management tracking: "AUTO" or "MANUAL" |
| SEGMENT_SPACE_MANAGEMENT (DBA_TABLESPACES) | Segment space management tracking: "AUTO" or "MANUAL" |
| SPACE (GV$TRANSACTION) | |
| SPACE (V$TRANSACTION) | |
| TABLE_SPACE (V$LOGMNR_CONTENTS) | |
| TABLE_SPACE (GV$LOGMNR_CONTENTS) | |
| TEMP_SPACE (GV$SQL_PLAN_STATISTICS_ALL) | |
| TEMP_SPACE (GV$SQL_PLAN) | |
| TEMP_SPACE (V$SQL_PLAN) | |
| TEMP_SPACE (V$SQL_PLAN_STATISTICS_ALL) | |
| TEMP_SPACE_PAGES (V$AW_OLAP) | |
| TEMP_SPACE_PAGES (GV$AW_OLAP) | |
| TEMP_SPACE_READS (V$AW_OLAP) | |
| TEMP_SPACE_READS (GV$AW_OLAP) | |
| USED_SPACE (V$SHARED_POOL_RESERVED) | |
| USED_SPACE (GV$SHARED_POOL_RESERVED) |