All Forums Database
04 Sep 2014
FreeSPacePercent(FSP) to avoid frequent PACKDISK run

Hi All,
It is said that to avoid frequent running of intence, resource consuming PACKDISK process, we have to define FreeSpace for each table inorder to make sure that free space is available during bulk loading.
PACKDISK command basically works at cylinders level where data of multiple tables may be present but FSP is defined while creating a table(Table level).
My actual question is when we run PACKDISK command, does it works on cylinders for each table as FSP will be defined for each table differently?
If "A" is a table with FSP=20% and "B" is a table with FSP=30%. And we see that space in cylinders is getting low. Then how the PACKDISK works for these 2 tables with different FSP?

Mahesh Abbigeri
Raja_KT 1246 posts Joined 07/09
04 Sep 2014

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.