I read this on another site. Its a sql command to find out if the DB is fragmented.

select * from dba_segments where extents > 10;

After I run this almost all of my tables are above 10, which the author of this article says "In general, if a table or index has more than 10 extents then rebuild it to fit into one extent". This is a pretty new DB and hasn't been used that much. Is this good advice?

Thanks Paul