RECLAIM UNUSED SPACE - SEGMENT & TABLESPACE Level

Hi All,

We have some of concurent jobs running to delete huge no.of records from various table, which does not reset the  high water mark. Thus resulting datafile getting exhaused(with AUTOEXTEND ON) option.

So, Would like to identify the segments(TABLE/INDEX/PARTITION) with unused space below high water mark, so that we can reset either by Alter table move/ alter table shrink etc.,

I see there are lots of suggestion out in the net, however, i would like to understand the most recommended/best practice on the same.

i see the following options available, pls recommend which one is better and provide if any recommended script to identify the problematic segmens/tablespaces to resize.