Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Estimate Chain Count

carajandbDec 4 2014 — edited Jan 11 2016

To identify tables with a need for reorganization it will be beneficial to have an advanced dbms_stats feature to estimate chain_cnt and other reorganization related columns for a table (e.g. avg_row_length, avg_space). Analyse table is not feasible because it destroys the optimizer statistics and analyze table list chained_rows into .. is too expensive.

Comments
Post Details
Added on Dec 4 2014
10 comments
843 views