Re: Table keeps growing inspite of purging

Your index will continue to grow due to fragmentation. You will have to drop and rebuild it to reduce the size of the B-tree. Depending on what you do with your data and the size of the table, you might be better off not having an index at all - do a couple of test runs.

Your table? If you are not updating the rows once they've been inserted, try pctfree 0, pctused 99. Fill up the data blocks, and immediately re-use blocks once freed up by your delete routine.

-- 
Wayne Linton
lintonw_at_cadvision.com


Sasha Ostojic wrote:


> 

> I have an application that writes several hundred records to a table every

> few minutes.  There is a cron job that runs every hour that deletes records

> older than two days from this table.  This has been running now for about

> three months.  The problem is that I noticed that the table is growing over

> time (the number of extents is growing).  I would have expected it to reach

> a certain size (after two days), and then the space freed by deleted records

> would be reused.  The table has one index, and it is still growing as well.

> 

> The table is created with PCTFREE 5 and PCTUSED 60. The index is PCTFREE 5.

> 

> Why is my table still growing?

> 

> Thanks in advance.

> 

> .sasha