DBA_TABLES
Description des tables (avec statistiques).
Nom de la colonne | Description |
EMPTY_BLOCKS | The number of empty (never used) data blocks in the table |
AVG_SPACE | The average available free space in the table |
CHAIN_CNT | The number of chained rows in the table |
AVG_ROW_LEN | The average row length, including row overhead |
DEGREE | The number of threads per instance for scanning the table |
INSTANCES | The number of instances across which the table is to be scanned |
CACHE | Whether the table is to be cached in the buffer cache |
OWNER | Owner of the table |
TABLE_NAME | Name of the table |
TABLESPACE_NAME | Name of the tablespace containing the table |
CLUSTER_NAME | Name of the cluster, if any, to which the table belongs |
PCT_FREE | Minimum percentage of free space in a block |
PCT_USED | Minimum percentage of used space in a block |
INI_TRANS | Initial number of transactions |
MAX_TRANS | Maximum number of transactions |
INITIAL_EXTENT | Size of the initial extent in bytes |
NEXT_EXTENT | Size of secondary extents in bytes |
MIN_EXTENTS | Minimum number of extents allowed in the segment |
MAX_EXTENTS | Maximum number of extents allowed in the segment |
PCT_INCREASE | Percentage increase in extent size |
FREELISTS | Number of process freelists allocated to this segment |
FREELIST_GROUPS | Number of freelist groups allocated to this segment |
BACKED_UP | Has table been backed up since last modification? |
NUM_ROWS | The number of rows in the table |
BLOCKS | The number of used data blocks in the table |