Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table reorg, : the Tablespace free size didn't change, but 1 week later ...

Dear all,

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 ?

Former Member
Former Member replied

yes u r right? when u click refresh it will run a report and update your statistics

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question