Table TST03

[Former Member]

Hi ,

In TST03 there is a big difference in the net table data and gross table data.

If we calculate from SP12 Temse objects occupied size is 540 MB, in the total spool space of TST03 ( ignoring the minor header data from TST01).Whereas, from DB02, occupied blocks of Temse objects equal to 6704 MB(used blocks*8/1024).Total space allocated to TST03 is 6712 MB.Can conclude there is a huge difference between the net table data and gross table data.

Could any one confirm that my analysis is correct and Moreover we have scheduled report RSBTCDEL and RSPO1042 , to delete the temse logs with a time period of last 2 days.But still there is a huge tablespace growth.would reorganizing works,I agree PCT free value change would effect.Could any one confirm that my analysis is correct .

Thanks ,

Sri

[Former Member]

Oops i found the Answer.In table ananlysis find out the free % in used blocks. Now compare the SP12 and Actual used blocks.which should be approximately equal.

Edited by: srisun on Apr 28, 2010 7:12 AM