hello,

After searching the old postings, I am still confused. Can someone clarify?

Is a table fragmented if it has double digit extents?

If I run a query like:

select segment_name, extents
from dba_segments
where extents > 10;

Should I reorg these tables based on this information?

(I understand the difference between row chaining and migration and I understand that this is a separate issue from multiple extents.)

Thanks for the insight!!!