侧边栏壁纸
博主头像
与晚风述往事博主等级

万般皆下品,唯有读书高。

  • 累计撰写 149 篇文章
  • 累计创建 29 个标签
  • 累计收到 7 条评论

目 录CONTENT

文章目录

DBA_TABLES静态数据字典视图

与晚风述往事
2021-12-08 / 0 评论 / 0 点赞 / 184 阅读 / 6,475 字 / 正在检测是否收录...
温馨提示:
本文最后更新于 2021-12-08,若内容或图片失效,请留言反馈。部分素材来自网络,若不小心影响到您的利益,请联系我们删除。

介绍

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
0

评论区