Huge difference by table TST03 between Memory allocation

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)

Huge difference by table TST03 between Memory allocation

Huge difference by table TST03 between Memory allocation

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

Huge difference by table TST03 between 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 ;

Huge difference by table TST03 between Memory allocation

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

Huge difference by table TST03 between Memory allocation

Final size ot the TST03 ;

Huge difference by table TST03 between Memory allocation

It’s nearly 1.7 GB  :)

Related OSS Notes ;

2203297 – Huge difference by table TST03 between database and SP12

2649378 – Table TST03 grow fast

 

 

 

 

 

Leave a Reply


+ seven = 16

Blogroll