Skip to Content

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

Table size higher after Online LOB conversion (BrSpace)

Hi all,

After several archiving processes run by the application team was the time to reorg the involved table to reclaim the free space. One of the tables (RFBLG) had a lot of WASTED space based on the statistics data:

BLOCKSNET_MBGROSS_MBWASTED_MB
Before Reorganization30.295.05110.195217.497207.302
After Reorganization37.124.387247.397266.52719.131

As you can see the growth in gross space was about 30% (266.527 - 217.497) and in net space was 23 times more (247.397 - 10.195).

Even having a Wasted space of 207.302MB before the reorg, the gross and net size of the table were increased.

As the table had a Long Raw field we run an Online Lob conversion with BRSpace to reorg the table online and convert to LOB.

Do you know any logical reason to have seach high increase after a reorg.

Thanks in advanced.

Cheers

Former Member
Not what you were looking for? View more on this topic or Ask a question