Oracle10g 查詢統計資訊的一些檢視

tolywang發表於2011-08-30
  • DBA_TABLES

  • DBA_INDEXES

  • DBA_OBJECT_TABLES

  • DBA_TAB_STATISTICS

  • DBA_IND_STATISTICS

  • DBA_TAB_COL_STATISTICS

  • DBA_TAB_HISTOGRAMS

  • DBA_PART_HISTOGRAMS

  • DBA_TAB_PARTITIONS

  • DBA_TAB_SUBPARTITIONS

  • DBA_IND_PARTITIONS

  • DBA_IND_SUBPARTITIONS

  • DBA_PART_COL_STATISTICS

  • DBA_SUBPART_COL_STATISTICS

  • DBA_SUBPART_HISTOGRAMS

  • DBA_CLUSTERS

  • 來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-706206/,如需轉載,請註明出處,否則將追究法律責任。

    相關文章