predict the free space before shrink

[mahajanakhil198]

He's absolutely correct.

I thought that you are referring to Segment Advisor in Database Control. I will check DBMS_ADVISOR and see if it helps in my case.

Thanks though!