Originally posted by aspdba
Does analyzing tables give details of chained rows and the migrating ones?
Yea, it does...

Code:
analyze table temp list chained rows into chained_rows;
Check this out for more info...

http://www.oracle.com/oramag/code/ti...ml?012201.html

HTH.