Oracle Database Discussions

Hi

I understand that its impossible to have fragmentation on locally managed tablespace but when i run the query below i get

select
tablespace_name,
COUNT(*) cnt_free_chunk,
decode( round((max(BYTES) / 1024),2), 
null,0, round((max(BYTES) / 1024),2)) largest_chunk
from dba_free_space
group by tablespace_name
order by 2 desc ,1

TABLESPACE_NAME                CNT_FREE_CHUNK              LARGEST_CHUNK
------------------------------              --------------                         -------------
USR_IDX_TBS                         1739                               2359296

The tablespace shows it was not plugged in and it is using LMT with ASSM.