I was doing some space management on my largest repo, and found that it is occupying 429 GB, and Segment Advisor said I could reclaim 129 GB of it. I checked the first table... It is 8.5 GB in 1.089 million blocks. Of that, 1.005 million blocks are between 75 - 100% empty. I expect this is due to inserting new rows above the HWM. Is this something I can adjust?
SQL> exec show_space('CONST_588','IGNITE','TABLE');
Unformatted Blocks ..................... 0
FS1 Blocks (0-25) ...................... 7
FS2 Blocks (25-50) ..................... 973
FS3 Blocks (50-75) ..................... 21,754
FS4 Blocks (75-100)..................... 1,005,143
Full Blocks ............................ 60,109
Total Blocks............................ 1,089,536
Total Bytes............................. 8,925,478,912
Total MBytes............................ 8,512
Unused Blocks........................... 0
