Reduce size LOBSEGMENT

[TMASaphir]

Hello Sap Expert,

The size of the lob segment SYS_LOB0000513160C00007$$ on the tablespace PSAPSR3 is quite huge around 32GB and I would like to reduce the space.

The table behind this lobsegment is SOFFCONT1. I have deleted entries on this table trough the report rsbcs_reorg.

After deletion, I have have reorganized the table SOFFCONT1 with the brtools.

Unfortunately, the space of the lob segment SYS_LOB0000513160C00007$$ is not decreasing.

Is there anything am I missing? or is it not the right way to reduce the size?

For any table, I can delete entries and reorganize the table, the space of the table is reducing but not for the lobsegment.

Thank you in advance for your feedbacks.

Best regards,

Christophe

[S_Sriram]

Hi Christophe.

Have you check this thread with same issue.

https://answers.sap.com/questions/10055271/lob-segment-large-in-size-than-tables.html

Regards

SS

[TMASaphir]

Hello Sriram,

I have checked your link, thank you.

Unfortunately,I did not find how to reduce the space used for the LOB segment.

I have a look to the OSS note 500340 about LOBs segment general topics and the OSS note 2142497, on this note, it says the following : "If the lobsegments belong to basis tables listed in SAP note 706478, you can follow the archiving methods listed in this SAP note 706478. For other application tables, please discuss with your application colleague for the archiving methods. Then, perform the table reorganization using brspace as per SAP note 646681 in order the regain the unused space."

I used the function 'reorganization table' of brtools, but after the reorg the space used is still high around 32go.

For remind, the lob segment is SYS_LOB0000589363C00007$$ and the table behind is SOFFCONT1.

Maybe 32 go is a "normal" size for this LOB segment. For information, the total number of selected documents retrieved by the report RSBCS_REORG is around 60k.

Thank you

Best regards,

Christophe

[roger_sant]

hello friends, any updates?

[Jakn]

Deleting entries from SOFFCONT1 does not automatically shrink the associated LOB segment. For LOBs, space is not released unless the LOB is moved or rebuilt. You need to reorganize the LOB segment explicitly (e.g. BRSPACE LOB reorg or MOVE LOB), or relocate content to a content server (RSIRPIRL). Otherwise, the LOB size remaining large is expected behavior.

[qwertie]

Hello Roger,

here you go

2142497 - What to do for large lobsegment on Oracle database?

br