Table reorg, : the Tablespace free size didn't change, but 1 week later ...
Last week, I did table reorg. on my SAP system, after that, from the T-code DB02, I found the table size shrinked but the tablespace free size remained unchanged.
But today (one week later), using T-code DB02, I found the whole tablespace shrinked by 10 GB, the amount was roughly equal to the size shrinked by the Table Reorg last week.
One more point, we did SAP server cold boot last Saturday night.
My questions :
(1)Why from DB02, I couldn't see the whole tablespace shrinked after I finished the table reorg ?
(2)Is it becuase the DB02 screen needed time to update or refresh the figure of free tablespace ?
(3)Was the increase of the free tablespace figure was due to the system cold boot last Saturday ?
Any ideal ?
yes u r right? when u click refresh it will run a report and update your statistics