小编给大家分享一下数据库中如何查看统计信息，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！

setechooffsetscanonsetlines150setpages66setverifyoffsetfeedbackoffsettermoutoffcolumnuservarnew_valueTable_Ownernoprintselectuseruservarfromdual;settermoutoncolumnTABLE_NAMEheading"Tablesownedby&Table_Owner"formata30selecttable_namefromdba_tableswhereowner=upper('&Table_Owner')orderby1/undefinetable_nameundefineownerpromptacceptownerprompt'PleaseenterNameofTableOwner(Null=&Table_Owner):'accepttable_nameprompt'PleaseenterTableNametoshowStatisticsfor:'columnTABLE_NAMEheading"Table|Name"formata15columnPARTITION_NAMEheading"Partition|Name"formata15columnSUBPARTITION_NAMEheading"SubPartition|Name"formata15columnNUM_ROWSheading"Number|ofRows"format9,999,999,999,990columnBLOCKSheading"Blocks"format999,990columnEMPTY_BLOCKSheading"Empty|Blocks"format999,999,990columnAVG_SPACEheading"Average|Space"format9,990columnCHAIN_CNTheading"Chain|Count"format999,990columnAVG_ROW_LENheading"Average|RowLen"format990columnCOLUMN_NAMEheading"Column|Name"formata25columnNULLABLEheadingNull|ableformata4columnNUM_DISTINCTheading"Distinct|Values"format999,999,990columnNUM_NULLSheading"Number|Nulls"format9,999,990columnNUM_BUCKETSheading"Number|Buckets"format990columnDENSITYheading"Density"format990columnINDEX_NAMEheading"Index|Name"formata15columnUNIQUENESSheading"Unique"formata9columnBLEVheading"B|Tree|Level"format90columnLEAF_BLOCKSheading"Leaf|Blks"format990columnDISTINCT_KEYSheading"Distinct|Keys"format9,999,999,990columnAVG_LEAF_BLOCKS_PER_KEYheading"Average|LeafBlocks|PerKey"format99,990columnAVG_DATA_BLOCKS_PER_KEYheading"Average|DataBlocks|PerKey"format99,990columnCLUSTERING_FACTORheading"Cluster|Factor"format999,999,990columnCOLUMN_POSITIONheading"Col|Pos"format990columncolheading"Column|Details"formata24columnCOLUMN_LENGTHheading"Col|Len"format9,990columnGLOBAL_STATSheading"Global|Stats"formata6columnUSER_STATSheading"User|Stats"formata6columnSAMPLE_SIZEheading"Sample|Size"format9,999,999,999,990columnto_char(t.last_analyzed,'MM-DD-YYYY')heading"Date|MM-DD-YYYY"formata10promptprompt***********promptTableLevelprompt***********promptselectTABLE_NAME,NUM_ROWS,BLOCKS,EMPTY_BLOCKS,AVG_SPACE,CHAIN_CNT,AVG_ROW_LEN,GLOBAL_STATS,USER_STATS,SAMPLE_SIZE,to_char(t.last_analyzed,'MM-DD-YYYY')fromdba_tablestwhereowner=upper(nvl('&&Owner',user))andtable_name=upper('&&Table_name')/selectCOLUMN_NAME,decode(t.DATA_TYPE,'NUMBER',t.DATA_TYPE||'('||decode(t.DATA_PRECISION,null,t.DATA_LENGTH||')',t.DATA_PRECISION||','||t.DATA_SCALE||')'),'DATE',t.DATA_TYPE,'LONG',t.DATA_TYPE,'LONGRAW',t.DATA_TYPE,'ROWID',t.DATA_TYPE,'MLSLABEL',t.DATA_TYPE,t.DATA_TYPE||'('||t.DATA_LENGTH||')')||''||decode(t.nullable,'N','NOTNULL','n','NOTNULL',NULL)col,NUM_DISTINCT,DENSITY,NUM_BUCKETS,NUM_NULLS,GLOBAL_STATS,USER_STATS,SAMPLE_SIZE,to_char(t.last_analyzed,'MM-DD-YYYY')fromdba_tab_columnstwheretable_name=upper('&Table_name')andowner=upper(nvl('&Owner',user))/selectINDEX_NAME,UNIQUENESS,BLEVELBLev,LEAF_BLOCKS,DISTINCT_KEYS,NUM_ROWS,AVG_LEAF_BLOCKS_PER_KEY,AVG_DATA_BLOCKS_PER_KEY,CLUSTERING_FACTOR,GLOBAL_STATS,USER_STATS,SAMPLE_SIZE,to_char(t.last_analyzed,'MM-DD-YYYY')fromdba_indexestwheretable_name=upper('&Table_name')andtable_owner=upper(nvl('&Owner',user))/breakonindex_nameselecti.INDEX_NAME,i.COLUMN_NAME,i.COLUMN_POSITION,decode(t.DATA_TYPE,'NUMBER',t.DATA_TYPE||'('||decode(t.DATA_PRECISION,null,t.DATA_LENGTH||')',t.DATA_PRECISION||','||t.DATA_SCALE||')'),'DATE',t.DATA_TYPE,'LONG',t.DATA_TYPE,'LONGRAW',t.DATA_TYPE,'ROWID',t.DATA_TYPE,'MLSLABEL',t.DATA_TYPE,t.DATA_TYPE||'('||t.DATA_LENGTH||')')||''||decode(t.nullable,'N','NOTNULL','n','NOTNULL',NULL)colfromdba_ind_columnsi,dba_tab_columnstwherei.table_name=upper('&Table_name')andowner=upper(nvl('&Owner',user))andi.table_name=t.table_nameandi.column_name=t.column_nameorderbyindex_name,column_position/promptprompt***************promptPartitionLevelprompt***************selectPARTITION_NAME,NUM_ROWS,BLOCKS,EMPTY_BLOCKS,AVG_SPACE,CHAIN_CNT,AVG_ROW_LEN,GLOBAL_STATS,USER_STATS,SAMPLE_SIZE,to_char(t.last_analyzed,'MM-DD-YYYY')fromdba_tab_partitionstwheretable_owner=upper(nvl('&&Owner',user))andtable_name=upper('&&Table_name')orderbypartition_position/breakonpartition_nameselectPARTITION_NAME,COLUMN_NAME,NUM_DISTINCT,DENSITY,NUM_BUCKETS,NUM_NULLS,GLOBAL_STATS,USER_STATS,SAMPLE_SIZE,to_char(t.last_analyzed,'MM-DD-YYYY')fromdba_PART_COL_STATISTICStwheretable_name=upper('&Table_name')andowner=upper(nvl('&Owner',user))/breakonpartition_nameselectt.INDEX_NAME,t.PARTITION_NAME,t.BLEVELBLev,t.LEAF_BLOCKS,t.DISTINCT_KEYS,t.NUM_ROWS,t.AVG_LEAF_BLOCKS_PER_KEY,t.AVG_DATA_BLOCKS_PER_KEY,t.CLUSTERING_FACTOR,t.GLOBAL_STATS,t.USER_STATS,t.SAMPLE_SIZE,to_char(t.last_analyzed,'MM-DD-YYYY')fromdba_ind_partitionst,dba_indexesiwherei.table_name=upper('&Table_name')andi.table_owner=upper(nvl('&Owner',user))andi.owner=t.index_ownerandi.index_name=t.index_name/promptprompt***************promptSubPartitionLevelprompt***************selectPARTITION_NAME,SUBPARTITION_NAME,NUM_ROWS,BLOCKS,EMPTY_BLOCKS,AVG_SPACE,CHAIN_CNT,AVG_ROW_LEN,GLOBAL_STATS,USER_STATS,SAMPLE_SIZE,to_char(t.last_analyzed,'MM-DD-YYYY')fromdba_tab_subpartitionstwheretable_owner=upper(nvl('&&Owner',user))andtable_name=upper('&&Table_name')orderbySUBPARTITION_POSITION/breakonpartition_nameselectp.PARTITION_NAME,t.SUBPARTITION_NAME,t.COLUMN_NAME,t.NUM_DISTINCT,t.DENSITY,t.NUM_BUCKETS,t.NUM_NULLS,t.GLOBAL_STATS,t.USER_STATS,t.SAMPLE_SIZE,to_char(t.last_analyzed,'MM-DD-YYYY')fromdba_SUBPART_COL_STATISTICSt,dba_tab_subpartitionspwheret.table_name=upper('&Table_name')andt.owner=upper(nvl('&Owner',user))andt.subpartition_name=p.subpartition_nameandt.owner=p.table_ownerandt.table_name=p.table_name/breakonpartition_nameselectt.INDEX_NAME,t.PARTITION_NAME,t.SUBPARTITION_NAME,t.BLEVELBLev,t.LEAF_BLOCKS,t.DISTINCT_KEYS,t.NUM_ROWS,t.AVG_LEAF_BLOCKS_PER_KEY,t.AVG_DATA_BLOCKS_PER_KEY,t.CLUSTERING_FACTOR,t.GLOBAL_STATS,t.USER_STATS,t.SAMPLE_SIZE,to_char(t.last_analyzed,'MM-DD-YYYY')fromdba_ind_subpartitionst,dba_indexesiwherei.table_name=upper('&Table_name')andi.table_owner=upper(nvl('&Owner',user))andi.owner=t.index_ownerandi.index_name=t.index_name/clearbreakssetechoon

***********TableLevel***********TableNumberEmptyAverageChainAverageGlobalUserSampleDateNameofRowsBlocksBlocksSpaceCountRowLenStatsStatsSizeMM-DD-YYYY--------------------------------------------------------------------------------------------T15,000200009YESNO5,00006-30-2003ColumnColumnDistinctNumberGlobalUserSampleDateNameDetailsValuesDensityBucketsNUM_NULLSStatsStatsSizeMM-DD-YYYY-----------------------------------------------------------------------------------------------------------------T1C1NUMBER(22)5,000010YESNO5,00006-30-2003T1C2NUMBER(22)7010YESNO5,00006-30-2003T1C3NUMBER(22)8010YESNO5,00006-30-2003BAverageAverageIndexTreeLeafDistinctNumberLeafBlocksDataBlocksClusterGlobalUserSampleDateNameUniqueLevelBlksKeysofRowsPerKeyPerKeyFactorStatsStatsSizeMM-DD-YYYY-------------------------------------------------------------------------------------------------------------------UN_T1NONUNIQUE1125,0005,0001112YESNO5,00006-30-2003IndexColumnColColumnNameNamePosDetails--------------------------------------------------------------------UN_T1T1C11NUMBER(22)***************PartitionLevel***************PartitionNumberEmptyAverageChainAverageGlobalUserSampleDateNameofRowsBlocksBlocksSpaceCountRowLenStatsStatsSizeMM-DD-YYYY--------------------------------------------------------------------------------------------Q12,144100009YESNO2,14406-30-2003Q22,856100009YESNO2,85606-30-2003PartitionColumnDistinctNumberGlobalUserSampleDateNameNameValuesDensityBucketsNUM_NULLSStatsStatsSizeMM-DD-YYYY--------------------------------------------------------------------------------------------------------Q1T1C12,144010YESNO2,14406-30-2003T1C23010YESNO2,14406-30-2003T1C38010YESNO2,14406-30-2003Q2T1C12,856010YESNO2,85606-30-2003T1C24010YESNO2,85606-30-2003T1C38010YESNO2,85606-30-2003BAverageAverageIndexPartitionTreeLeafDistinctNumberLeafBlocksDataBlocksClusterGlobalUserSampleDateNameNameLevelBlksKeysofRowsPerKeyPerKeyFactorStatsStatsSizeMM-DD-YYYY-------------------------------------------------------------------------------------------------------------------------UN_T1Q11125,0005,0001112YESNO5,00006-30-2003UN_T1Q21125,0005,0001112YESNO5,00006-30-2003***************SubPartitionLevel***************PartitionSubPartitionNumberEmptyAverageChainAverageGlobalUserSampleDateNameNameofRowsBlocksBlocksSpaceCountRowLenStatsStatsSizeMM-DD-YYYY-----------------------------------------------------------------------------------------------------------Q1SYS_SUBP49780350009YESNO80306-30-2003Q2SYS_SUBP4991,07250009YESNO1,07206-30-2003Q1SYS_SUBP4981,34150009YESNO1,34106-30-2003Q2SYS_SUBP5001,78450009YESNO1,78406-30-2003PartitionSubPartitionColumnDistinctNumberGlobalUserSampleDateNameNameNameValuesDensityBucketsNUM_NULLSStatsStatsSizeMM-DD-YYYY-----------------------------------------------------------------------------------------------------------------------Q1SYS_SUBP497T1C1803010YESNO80306-30-2003SYS_SUBP498T1C11,341010YESNO1,34106-30-2003SYS_SUBP497T1C23010YESNO80306-30-2003SYS_SUBP498T1C23010YESNO1,34106-30-2003SYS_SUBP497T1C33010YESNO80306-30-2003SYS_SUBP498T1C35010YESNO1,34106-30-2003Q2SYS_SUBP499T1C11,072010YESNO1,07206-30-2003SYS_SUBP500T1C11,784010YESNO1,78406-30-2003SYS_SUBP499T1C24010YESNO1,07206-30-2003SYS_SUBP500T1C24010YESNO1,78406-30-2003SYS_SUBP499T1C33010YESNO1,07206-30-2003SYS_SUBP500T1C35010YESNO1,78406-30-2003BAverageAverageIndexPartitionSubPartitionTreeLeafDistinctNumberLeafBlocksDataBlocksClusterGlobalUserSampleDateNameNameNameLevelBlksKeysofRowsPerKeyPerKeyFactorStatsStatsSizeMM-DD-YYY---------------------------------------------------------------------------------------------------------------------------------------UN_T1Q1SYS_SUBP49712803803112YESNO80306-30-200UN_T1SYS_SUBP498131,3411,341113YESNO1,34106-30-200UN_T1Q2SYS_SUBP499131,0721,072113YESNO1,07206-30-200UN_T1SYS_SUBP500141,7841,784114YESNO1,78406-30-200

以上是“数据库中如何查看统计信息”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注亿速云行业资讯频道！