SAP ECC on Oracle - large LOB segment on TST03

[garethreeceuk]

Hi,

SAP ECC system running on Oracle & Windows.

After some uncontrolled spool activity and subsequent housekeeping, we are left with table TST03 having a table size of around 2Gb (which is fine) but the LOB segment on the DCONTENT field is around 200Gb.

What is the recommended approach to reduce this - reorg the table, or shrink the LOB segment?

Thanks!

[former_member207186 · Accepted solution]

Hi,

Regarding this issue, you can check SAP Note and SAP knowledge base articles below:
2388483 - How-To: Data Management for Technical Tables (especially section TST03)
2649378 - Table TST03 grow fast
1922200 - TUNING INSERT PERFORMANCE ON TABLE TST03
2142497 - What to do for large lobsegment on Oracle database?

Regards,
Bíborka

[garethreeceuk · Accepted solution]

Note 2142497 confirms that the correct method of regaining the space is to reorg the table via BRTools.