DBA_TAB_STATISTICS view
DBA_TAB_STATISTICS displays optimizer statistics for all tables in the database. Its columns are the same as those in ALL_TAB_STATISTICS. ALL_TAB_STATISTICS displays optimizer statistics for tables that the current user can access. USER_TAB_STATISTICS displays optimizer statistics for tables owned by the current user. This view does not display the owner column. ColumnDatatypeNULLDescriptionOWNERVARCHAR2 (30)
OwnerTABLE_NAMEVARCHAR2 of the Owner of the object object (30)
Name of the table table name PARTITION_NAMEVARCHAR2 (30)
Name of the partition partition name PARTITION_POSITIONNUMBER
The location of the Position of the partition within the table partition in the table SUBPARTITION_NAMEVARCHAR2 (30)
The name of the Name of the subpartition subpartition SUBPARTITION_POSITIONNUMBER
The location of the Position of the subpartition within the partition subpartition in the table OBJECT_TYPEVARCHAR2 (12)
Type of Type of the object:TABLEPARTITIONSUBPARTITION table: table partition table child partition table NUM_ROWSNUMBER
How many rows record BLOCKSNUMBER in the Number of rows in the object table
How many EMPTY_BLOCKSNUMBER are there in the Number of used blocks in the object table
Number of empty blocks in the Number of empty blocks in the object table AVG_SPACENUMBER
Average free space available in the Average available free space in the object object CHAIN_CNTNUMBER
The number of row migrations or row links that occur in the Number of chained rows in the object table AVG_ROW_LENNUMBER
Average row length of Average row length, including row overhead, including line cost AVG_SPACE_FREELIST_BLOCKSNUMBER
Average free space NUM_FREELIST_BLOCKSNUMBER of all blocks in Average freespace of all blocks on a freelist free list
Number of blocks on Number of blocks on the freelist Free list AVG_CACHED_BLOCKSNUMBER
Average number of blocks in the Average number of blocks in the buffer cache buffer cache AVG_CACHE_HIT_RATIONUMBER
Average cache hit ratio of Average cache hit ratio for the object objects SAMPLE_SIZENUMBER
Sampling ratio LAST_ANALYZEDDATE when Sample size used in analyzing the table analyzes the table
Time of Date of the most recent time the table was analyzed's last analysis table GLOBAL_STATSVARCHAR2 (3)
Whether the statistics of Indicates whether statistics were calculated without merging underlying partitions (YES) or not (NO) as a whole (partition table) are accurately indicated by user statistics (YES) or (NO) USER_STATSVARCHAR2 (3)
Indicates whether statistics were entered directly by the user (YES) or not (NO) indicates whether or not user statistics (YES) or (NO) STATTYPE_LOCKEDVARCHAR2 (5)
Type of Type of statistics lock:DATACACHEALL statistics: data cache all: indicates that the statistics are locked STALE_STATSVARCHAR2 (3)
Whether Indicates whether statistics for the object are stale (YES) or not (NO) statistics expires (yes expires) or (no does not expire)
