Reclaim wasted space

Hello All,

I am trying to reclaim the wasted space on oracle 11g database using oracle EM 10 grid control segment advisor.

I have used same feature in OEM 12c ,where i was getting recommendations for reorganize and shrink.But in 10g i am only getting shrink recommendations and it is also looks not correct.

Manually i have run this script to know the wasted space as we have maintain statistics on objects. I see there is a lot of wasted space.

select

a.owner,

a.segment_name,

a.segment_type,

round(a.bytes/1024/1024,0) MBS,

round((a.bytes-(b.num_rows*b.avg_row_len) )/1024/1024,0) WASTED