Sometimes table TST03 can appear to be very large with it’s LOB segment, in this case, we need to check and compare the “Memory allocation” and “Database” sizes to start improving steps.

First of all we need to check Database size via below steps ;

ST04 -> Space -> Segments -> Detailed Analysis (Aggregated)

In our example, the size of the table TST03 on database level is more than 210 GB with the related LOB segment.

Now we need to check Memory allacation size like below ;

SP12 -> TemSe Data Storage -> Memory allocation

The line “In database” shows the amount of data stored in the database in bytes, for us this  is around 2.3 GB

If the this size much less than database size (2.3 GB much less than 210 GB for our case)

Then we need to set the value for PCTFree to 1% by table TST03 so that the wasted space is minimized.

To do this ;

Now we can start a rebuild operation on TST03 table to gain the database empty size ;

Final size ot the TST03 ;

It’s nearly 1.7 GB 

Related OSS Notes ;

2203297 – Huge difference by table TST03 between database and SP12

2649378 – Table TST03 grow fast