Sureshy,

What should I be looking for with the query:

select tablespace_name, count(*) from dba_free_space
group by tablespace_name

What results would indicate fragmentation? More than 10, More than 20?

And what steps should I take to correct this fragmentation?