|
Column |
Datatype |
NULL |
Description |
|
OWNER |
VARCHAR2(30) |
Owner of the object
對(duì)象的owner | |
|
TABLE_NAME |
VARCHAR2(30) |
Name of the table 表名 | |
|
PARTITION_NAME |
VARCHAR2(30) |
Name of the partition
分區(qū)名 | |
|
PARTITION_POSITION |
NUMBER |
Position of the partition within the table 分區(qū)在表中的位置 | |
|
SUBPARTITION_NAME |
VARCHAR2(30) |
Name of the subpartition
子分區(qū)的名字 | |
|
SUBPARTITION_POSITION |
NUMBER |
Position of the subpartition within the partition 子分區(qū)在表中的位置 | |
|
OBJECT_TYPE |
VARCHAR2(12) |
Type of the object:
表的類型： 表 分區(qū)表 子分區(qū)表 | |
|
NUM_ROWS |
NUMBER |
Number of rows in the object 表中有多少行記錄 | |
|
BLOCKS |
NUMBER |
Number of used blocks in the object 表有多少塊 | |
|
EMPTY_BLOCKS |
NUMBER |
Number of empty blocks in the object 表中空塊的數(shù)量 | |
|
AVG_SPACE |
NUMBER |
Average available free space in the object 對(duì)象中可用的平均空閑空間 | |
|
CHAIN_CNT |
NUMBER |
Number of chained rows in the object 表中發(fā)生行遷移或者行鏈接的數(shù)量 | |
|
AVG_ROW_LEN |
NUMBER |
Average row length, including row overhead 平均行長(zhǎng)度，包括行開銷 | |
|
AVG_SPACE_FREELIST_BLOCKS |
NUMBER |
Average freespace of all blocks on a freelist 自由列表中所有塊的平均自由空間 | |
|
NUM_FREELIST_BLOCKS |
NUMBER |
Number of blocks on the freelist 自由列表上的塊數(shù) | |
|
AVG_CACHED_BLOCKS |
NUMBER |
Average number of blocks in the buffer cache 緩沖區(qū)緩存中的平均塊數(shù) | |
|
AVG_CACHE_HIT_RATIO |
NUMBER |
Average cache hit ratio for the object 對(duì)象的平均緩存命中率 | |
|
SAMPLE_SIZE |
NUMBER |
Sample size used in analyzing the table 分析表時(shí)的采樣比例 | |
|
LAST_ANALYZED |
DATE |
Date of the most recent time the table was analyzed 最近一次分析表的時(shí)間 | |
|
GLOBAL_STATS |
VARCHAR2(3) |
Indicates whether statistics were calculated without merging underlying partitions (YES) or not (NO) 作為一個(gè)整體（分區(qū)表）表的統(tǒng)計(jì)的是否準(zhǔn)確表示是否被用戶統(tǒng)計(jì)信息 ( YES ) or ( NO ) | |
|
USER_STATS |
VARCHAR2(3) |
Indicates whether statistics were entered directly by the user (
YES
) or not (
NO
) 表示是否被用戶統(tǒng)計(jì)信息 ( YES ) or ( NO ) | |
|
STATTYPE_LOCKED |
VARCHAR2(5) |
Type of statistics lock:
統(tǒng)計(jì)信息的類型： data cache all：表示統(tǒng)計(jì)信息被鎖定 | |
|
STALE_STATS |
VARCHAR2(3) |
Indicates whether statistics for the object are stale (YES) or not (NO) 統(tǒng)計(jì)信息是否過(guò)期（yes 過(guò)期）或者（no 未過(guò)期） |
重慶分公司
重慶分公司
