cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ECC on Oracle - large LOB segment on TST03

garethreeceuk
Explorer
0 Kudos
603

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!

View Entire Topic
former_member207186
Contributor
0 Kudos

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
Explorer

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