介绍
DBA_TABLES视图能够让我们查询到当前数据库中的所有关系表的信息。
视图详情
| 字段名 | 字段类型 | 描述 | 译 | 备注 |
| OWNER | VARCHAR2(30) | Owner of the table | 表的拥有者 | |
| TABLE_NAME | VARCHAR2(30) | Name of the table | 表名 | |
| TABLESPACE_NAME | VARCHAR2(30) | Name of the tablespace containing the table; NULL for partitioned, temporary, and index-organized tables | 存储表的表空间名称 | 分区、临时表和索引组织表此字段为null |
| CLUSTER_NAME | VARCHAR2(30) | Name of the cluster, if any, to which the table belongs | 如果是簇表，则显示簇名称 | |
| IOT_NAME | VARCHAR2(30) | Name of the index-organized table, if any, to which the overflow or mapping table entry belongs. If the IOT_TYPE column is not NULL, then this column contains the base table name. | 索引组织表的表名 | |
| STATUS | VARCHAR2(8) | If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID) | 表的状态，通常可能发生在drop table失败后，则该表会不可用(UNUSABLE) | |
| PCT_FREE | NUMBER | Minimum percentage of free space in a block; NULL for partitioned tables | 块最少剩余的百分比 | 分区表显示为NULL |
| PCT_USED | NUMBER | Minimum percentage of used space in a block; NULL for partitioned tables | 块最少使用的百分比 | 分区表显示为NULL |
| INI_TRANS | NUMBER | Initial number of transactions; NULL for partitioned tables | 初始事务数量 | 分区表显示为NULL |
| MAX_TRANS | NUMBER | Maximum number of transactions; NULL for partitioned tables | 最大事务数量 | 分区表显示为NULL |
| INITIAL_EXTENT | NUMBER | Size of the initial extent (in bytes); NULL for partitioned tables | 初始区(范围)的大小，以字节(bytes)为单位 | 分区表显示为NULL |
| NEXT_EXTENT | NUMBER | Size of secondary extents (in bytes); NULL for partitioned tables | 下次区(范围)的大小，以字节(bytes)为单位 | 分区表显示为NULL |
| MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment; NULL for partitioned tables | 段的最小区(范围)个数 | 分区表显示为NULL |
| MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment; NULL for partitioned tables | 段的最大区(范围)个数 | 分区表显示为NULL |
| PCT_INCREASE | NUMBER | Percentage increase in extent size; NULL for partitioned tables | 区(范围)增加的百分比 | 分区表显示为NULL |
| FREELISTS | NUMBER | Number of process freelists allocated to the segment; NULL for partitioned tables | 分配给段的空闲列表数量 | 分区表显示为NULL |
| FREELIST_GROUPS | NUMBER | Number of freelist groups allocated to the segment; NULL for partitioned tables | 分配给段的空闲列表的组数量 | 分区表显示为NULL |
| LOGGING | VARCHAR2(3) | Indicates whether or not changes to the table are logged; NULL for partitioned tables: YES NO | 是否进行日志记录： 是 否 | |
| BACKED_UP | VARCHAR2(1) | Indicates whether the table has been backed up since the last modification (Y) or not (N) | 自上次修改表后是否已备份表,Y表示已备份，N表示未备份 | |
| NUM_ROWS | NUMBER | Number of rows in the table | 表中的行数 | 如果数据跟实际数据不对，则表明该表的统计信息过旧。 |
| BLOCKS | NUMBER | Number of used data blocks in the table | 表使用的数据块数量 | 如果数据跟实际数据不对，则表明该表的统计信息过旧。 |
| EMPTY_BLOCKS | NUMBER | Number of empty (never used) data blocks in the table. This column is populated only if you collect statistics on the table using the DBMS_STATS package. | 表中的空(从未使用)的数据块数量 | 只有使用DBMS_STATS包收集统计信息后，才会显示该值 |
| AVG_SPACE | NUMBER | Average amount of free space, in bytes, in a data block allocated to the table | 表中的数据块的平均可用空间大小，以字节(bytes)为单位 | |
| CHAIN_CNT | NUMBER | Number of rows in the table that are chained from one data block to another, or which have migrated to a new block, requiring a link to preserve the old ROWID | 表中有行迁移或行链接的行数 | |
| AVG_ROW_LEN | NUMBER | Average length of a row in the table (in bytes) | 表中行的平均长度，以字节为单位 | |
| AVG_SPACE_FREELIST_BLOCKS | NUMBER | Average freespace of all blocks on a freelist | ||
| NUM_FREELIST_BLOCKS | NUMBER | Number of blocks on the freelist | 空闲列表的块数 | |
| DEGREE | VARCHAR2(10) | Number of threads per instance for scanning the table, or DEFAULT | 扫描表或默认每个实例的线程数 | |
| INSTANCES | VARCHAR2(10) | Number of instances across which the table is to be scanned, or DEFAULT | 扫描表或默认的实例数 | |
| CACHE | VARCHAR2(5) | Indicates whether the table is to be cached in the buffer cache (Y) or not (N) | 表是否在缓冲区缓存，Y表示缓存，N表示不缓存 | |
| TABLE_LOCK | VARCHAR2(8) | Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED) | 表是否启用了表锁定，ENABLED表示启用，DISABLED表示禁用 | |
| SAMPLE_SIZE | NUMBER | Sample size used in analyzing this table | 表的统计信息收集的行数 | 此行数跟实际行数越一致，则该表生成的执行计划越精准 |
| LAST_ANALYZED | DATE | Date on which this table was most recently analyzed | 表最近收集统计信息的日期 | |
| PARTITIONED | VARCHAR2(3) | Indicates whether the table is partitioned (YES) or not (NO) | 表是否为分区表，YES表示分区表，NO表示非分区表 | |
| IOT_TYPE | VARCHAR2(12) | If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. If the table is not an index-organized table, then IOT_TYPE is NULL. | 表如果是索引组织表，则该值可能为IOT、IOT_OVERFLOW和IOT_MAPPAP；如果不是索引组织表，则该值为NULL | |
| TEMPORARY | VARCHAR2(1) | Indicates whether the table is temporary (Y) or not (N) | 表是否为临时表，Y表示临时表，N表示非临时表 | |
| SECONDARY | VARCHAR2(1) | Indicates whether the table is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N) | 该表是否为ODCIIndexCreate方法创建的辅助对象 | |
| NESTED | VARCHAR2(3) | Indicates whether the table is a nested table (YES) or not (NO) | 表是否为嵌套表，YES表示是嵌套表，NO表示不是嵌套表 | |
| BUFFER_POOL | VARCHAR2(7) | Buffer pool for the table; NULL for partitioned tables: DEFAULT KEEP RECYCLE NULL | 表的缓冲池： 默认 保持池 销毁池 NULL | 分区表的为NULL |
| FLASH_CACHE | VARCHAR2(7) | Database Smart Flash Cache hint to be used for table blocks: DEFAULT KEEP NONE | 数据库智能闪存缓存： 默认 KEEP 无 | |
| CELL_FLASH_CACHE | VARCHAR2(7) | Cell flash cache hint to be used for table blocks: DEFAULT KEEP NONE | ||
| ROW_MOVEMENT | VARCHAR2(8) | Indicates whether partitioned row movement is enabled (ENABLED) or disabled (DISABLED) | 是否启用了行移动，ENABLED表示启用，DISABLED表示禁用 | |
| GLOBAL_STATS | VARCHAR2(3) | For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES) or whether they were not collected and have to be estimated from statistics on underlying partitions and subpartitions (NO) | 整个分区表的统计信息是否准确(未收集)，YES表示准确，NO表示不准确(未收集) | |
| USER_STATS | VARCHAR2(3) | Indicates whether statistics were entered directly by the user (YES) or not (NO) | 用户是否直接输入统计信息，YES表示直接输入，NO表示非直接输入 | |
| DURATION | VARCHAR2(15) | Indicates the duration of a temporary table: SYS$SESSION - Rows are preserved for the duration of the session SYS$TRANSACTION - Rows are deleted after COMMIT | 临时表的持续时间： SYS$SESSION - 会话期间保留行 SYS$TRANSACTION - 在事务提交前保留行 | |
| SKIP_CORRUPT | VARCHAR2(8) | Indicates whether Oracle Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED). To enable this feature, run the DBMS_REPAIR.SKIP_CORRUPT_BLOCKS procedure. | Oracle是否忽略了表和索引扫描或引发错误的块。 | 启用此功能，需要运行DBMS_REPAIR.SKIP_CORRUPT_BLOCKS存储过程 |
| MONITORING | VARCHAR2(3) | Indicates whether the table has the MONITORING attribute set (YES) or not (NO) | 表是否有配置属性监控，YES表示有配置，NO表示没有配置 | |
| CLUSTER_OWNER | VARCHAR2(30) | Owner of the cluster, if any, to which the table belongs | 簇表的所有者 | |
| DEPENDENCIES | VARCHAR2(8) | Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED) | 表是否启用了行级依赖关系跟踪，ENANLED表示启用，DISABLED表示禁用 | |
| COMPRESSION | VARCHAR2(8) | Indicates whether table compression is enabled (ENABLED) or not (DISABLED); NULL for partitioned tables | 表是否启用压缩，ENABLED表示启用，DISABLED表示禁用 | 分区表显示为NULL |
| COMPRESS_FOR | VARCHAR2(12) | Default compression for what kind of operations: BASIC OLTP QUERY LOW QUERY HIGH ARCHIVE LOW ARCHIVE HIGH NULL | 表的压缩类型： 基础压缩 在线事务压缩 QUERY LOW QUERY HIGH ARCHIVE LOW ARCHIVE HIGH 不压缩 | |
| DROPPED | VARCHAR2(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO); NULL for partitioned tables | 表是否已被删除并放在回收站中，YES表示已删除并在回收站，NO表示未删除 | 分区表显示为NULL |
| READ_ONLY | VARCHAR2(3) | Indicates whether the table IS READ-ONLY (YES) or not (NO) | 表是否为只读，YES表示为只能读取，NO表示为不是只读 | |
| SEGMENT_CREATED | VARCHAR2(3) | Indicates whether the table segment is created (YES) or not (NO) | 创建DB Link的时间 | |
| RESULT_CACHE | VARCHAR2(7) | Result cache mode annotation for the table: DEFAULT - Table has not been annotated FORCE MANUAL | 结果缓存模式注释： DEFAULT - 表未注明 FORCE MANUAL |
评论区