Re: Free space not re-used

Hi Mark,

yes there is a long column in the table For insert , delete and commit : during the day we do n (insert+commit) and the night we delete n/5 rows + 1 commit at the end Just beforepost this question , drop pctused to 80% (4 days ago) and since the extent problem doesn't seem occur.
But to be sure I will decrease it again to 60 or 70% BR
Olivier

markp7832_at_my-deja.com wrote:

> Two question for Oliver.
>
> Do you have a column of type long in this table. If you do it seems to
> me that the manual used to say something to the effect that inserts
> with long columns go to unused blocks. I do not remember the details
> but I have seen this type of behavior when a long was involved.
>
> My other question is when do you do the commit? If you do not do it
> after the delete but before the insert then this may also have an
> effect on the space allocation. I know it has an effect with indexes.
> If you delete all the rows within an index block the block goes back on
> the free list. If you reinsert the same rows after the delete without
> a commit you take an extent, but if you commit between the delete and
> insert no extent is taken.
>
> I would ajust the pctfree and pctused such that the sum of the two was
> equal to no more than 100 - an average row length.
>
> --
> Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 18 2000 - 15:02:59 CST