I have run dbms_advisor using procedures mentioned in oracle doc. Then used following sql to see findings.
select type, message, more_info from dba_advisor_findings where task_id=35422;
PROBLEM The free space in the object is less than 10MB. Allocated Space:65536: Used Space:40955: Reclaimable Space :24581:
PROBLEM The free space in the object is less than 10MB. Allocated Space:65536: Used Space:28373: Reclaimable Space :37163:
INFORMATION Enable row movement of the table PMS.ROADS and perform shrink, estimated savings is 11722299 bytes. Allocated Space:13631488: Used Space:1909189: Reclaimable Space :11722299:
(1) I dont know the action to be taken on problem "The free space in the object is less than 10MB", please suggest me.
(2) To reclaim space shall i use SHRINK SPACE or SHRINK SPACE COMPACT in alter table ?
(3) If my table contains column of geometry type which is collection of varrays whether the advisor consider this and can i use shrink space ?