would it be save to runDBMS_SPACE.OBJECT_SPACE_USAGE to check for chain_pcent > 0 without disturbing DBMS_STATS at all?
just a guess - never tried yet.And I also doesn't see a valid answer for the question between chained and migrated rows there.
br. Martin -- Martin Berger http://berxblog.blogspot.com Am 06.11.2008 um 10:35 schrieb Christian Antognini:
Hi JoelThe difference between dba_tables.chain_cnt and what is contained in chained_rows table now is still a mystery. Stats are collected nightly.DBMS_STATS doesn't compute the value chain_cnt. Therefore, there are twopossibilities: 1) dba_tables.chain_cnt = 0 2) dba_tables.chain_cnt > 0If 1, either the table doesn't contain chained/migrated rows or ANALYZEwas never used to compute statistics for it.If 2, at some time in the past the statistics were compute with ANALYZE.Since DBMS_STATS doesn't compute it, you see the value at the time of the last execution of ANALYZE.