Shulou(Shulou.com)06/01 Report--

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)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.