Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

关于直方图信息的查询

cittahanNov 14 2012 — edited Mar 28 2013
在dba_tab_col_statistics视图中有histograms字段


对一张表做dbms_stats.gather_table_stats(user,'testbp',cascade=>true);


发现dba_tab_col_statistics中histograms的值为none


在user_histograms视图里面的信息却包含列的相关信息


按照我的理解,做表的信息收集,按照默认情况是会收集列上直方图信息的,那为什么dba_tab_col_statistics中histograms的值为none呢?

帖子经 cittahan编辑过
This post has been answered by LiuMaclean(刘相兵) on Nov 14 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2013
Added on Nov 14 2012
2 comments
785 views