Oracle Database Discussions

Hi
Couple of our apps admins say that some of our tablespaces are fragmentated .
So when I asked them to confirm they sent me query below

SELECT fs.tablespace_name, df.file_name, COUNT(*) AS fragments,
ROUND(SUM(fs.bytes)/1024,2) AS total_kb, ROUND(MAX(fs.bytes)/1024,2) AS biggest_kb
FROM DBA_FREE_SPACE fs, DBA_DATA_FILES df
WHERE fs.file_id(+) = df.file_id
GROUP BY fs.tablespace_name,df.file_name;

We are using oracle 9.2.0.6
and
when i query
select extent_management from dba_tablespaces
where tablespace_name='SYSTEM';
It show my tablespaces are locally managed tablespaces.

Now my question is

Can locally managed tablespaces in 9i get fregmented,
as far as i know locally managed tablespaces can never get fragmented.....
If YES
How can i confirm that?
and what tablespace are fragmented(how would i know any query--plz help)

and how can i defragment them(could some one give me the procedure)

Message was edited by:
vik121583