DBA_TAB_STATISTICS显示数据库中所有表的优化器统计信息。它的列与ALL_TAB_STATISTICS中的列相同。ALL_TAB_STATISTICS显示当前用户可以访问的表的优化器统计信息。USER_TAB_STATISTICS显示当前用户拥有的表的优化器统计信息。此视图不显示所有者列。ColumnDatatypeNULLDescriptionOWNERVARCHAR2(30)
Owner of the object对象的ownerTABLE_NAMEVARCHAR2(30)
Name of the table表名PARTITION_NAMEVARCHAR2(30)
Name of the partition分区名PARTITION_POSITIONNUMBER
Position of the partition within the table分区在表中的位置SUBPARTITION_NAMEVARCHAR2(30)
Name of the subpartition子分区的名字SUBPARTITION_POSITIONNUMBER
Position of the subpartition within the partition子分区在表中的位置OBJECT_TYPEVARCHAR2(12)
Type of the object:TABLEPARTITIONSUBPARTITION表的类型：表分区表子分区表NUM_ROWSNUMBER
Number of rows in the object表中有多少行记录BLOCKSNUMBER
Number of used blocks in the object表有多少块EMPTY_BLOCKSNUMBER
Number of empty blocks in the object表中空块的数量AVG_SPACENUMBER
Average available free space in the object对象中可用的平均空闲空间CHAIN_CNTNUMBER
Number of chained rows in the object表中发生行迁移或者行链接的数量AVG_ROW_LENNUMBER
Average row length, including row overhead平均行长度，包括行开销AVG_SPACE_FREELIST_BLOCKSNUMBER
Average freespace of all blocks on a freelist自由列表中所有块的平均自由空间NUM_FREELIST_BLOCKSNUMBER
Number of blocks on the freelist自由列表上的块数AVG_CACHED_BLOCKSNUMBER
Average number of blocks in the buffer cache缓冲区缓存中的平均块数AVG_CACHE_HIT_RATIONUMBER
Average cache hit ratio for the object对象的平均缓存命中率SAMPLE_SIZENUMBER
Sample size used in analyzing the table分析表时的采样比例LAST_ANALYZEDDATE
Date of the most recent time the table was analyzed最近一次分析表的时间GLOBAL_STATSVARCHAR2(3)
Indicates whether statistics were calculated without merging underlying partitions (YES) or not (NO)作为一个整体（分区表）表的统计的是否准确表示是否被用户统计信息 ( YES ) or ( NO )USER_STATSVARCHAR2(3)
Indicates whether statistics were entered directly by the user (YES) or not (NO)表示是否被用户统计信息 ( YES ) or ( NO )STATTYPE_LOCKEDVARCHAR2(5)
Type of statistics lock:DATACACHEALL统计信息的类型：datacacheall：表示统计信息被锁定STALE_STATSVARCHAR2(3)
Indicates whether statistics for the object are stale (YES) or not (NO)统计信息是否过期（yes 过期）或者（no 未过期）