Table: ALL_ALL_TABLES
Description of all object and relational tables accessible to the user
| Column Name | Description |
|---|---|
| AVG_ROW_LEN | The average row length, including row overhead |
| AVG_SPACE | The average available free space in the table |
| AVG_SPACE_FREELIST_BLOCKS | The average freespace of all blocks on a freelist |
| BACKED_UP | Has table been backed up since last modification? |
| BLOCKS | The number of used blocks in the table |
| BUFFER_POOL | The default buffer pool to be used for table blocks |
| CACHE | Whether the table is to be cached in the buffer cache |
| CHAIN_CNT | The number of chained rows in the table |
| CLUSTER_NAME | Name of the cluster, if any, to which the table belongs |
| CLUSTER_OWNER | Owner of the cluster, if any, to which the table belongs |
| COMPRESSION | Whether table compression is enabled or not |
| DEGREE | The number of threads per instance for scanning the table |
| DEPENDENCIES | Should we keep track of row level dependencies? |
| DURATION | If temporary table, then duration is sys$session or sys$transaction else NULL |
| EMPTY_BLOCKS | The number of empty (never used) blocks in the table |
| FREELISTS | Number of process freelists allocated in this segment |
| FREELIST_GROUPS | Number of freelist groups allocated in this segment |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| INITIAL_EXTENT | Size of the initial extent in bytes |
| INI_TRANS | Initial number of transactions |
| INSTANCES | The number of instances across which the table is to be scanned |
| IOT_NAME | Name of the index-only table, if any, to which the overflow or mapping table entry belongs |
| IOT_TYPE | If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL |
| LAST_ANALYZED | The date of the most recent time this table was analyzed |
| LOGGING | Logging attribute |
| MAX_EXTENTS | Maximum number of extents allowed in the segment |
| MAX_TRANS | Maximum number of transactions |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| MONITORING | Should we keep track of the amount of modification? |
| NESTED | Is the table a nested table? |
| NEXT_EXTENT | Size of secondary extents in bytes |
| NUM_FREELIST_BLOCKS | The number of blocks on the freelist |
| NUM_ROWS | The number of rows in the table |
| OBJECT_ID_TYPE | If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED |
| OWNER | Owner of the table |
| PARTITIONED | Is this table partitioned? YES or NO |
| PCT_FREE | Minimum percentage of free space in a block |
| PCT_INCREASE | Percentage increase in extent size |
| PCT_USED | Minimum percentage of used space in a block |
| ROW_MOVEMENT | Whether partitioned row movement is enabled or disabled |
| SAMPLE_SIZE | The sample size used in analyzing this table |
| SECONDARY | Is this table object created as part of icreate for domain indexes? |
| SKIP_CORRUPT | Whether skip corrupt blocks is enabled or disabled |
| TABLESPACE_NAME | Name of the tablespace containing the table |
| TABLE_LOCK | Whether table locking is enabled or disabled |
| TABLE_NAME | Name of the table |
| TABLE_TYPE | Type of the table if the table is an object table |
| TABLE_TYPE_OWNER | Owner of the type of the table if the table is an object table |
| TEMPORARY | Can the current session only see data that it place in this object itself? |
| USER_STATS | Were the statistics entered directly by the user? |