Hi everyone,

I have kinda strange situation that I need an explaination, I hope some of you can me a good hint. We have a large table that has alot of inserts and the table is growing at a fast pace. To minimize this growth, we implement a purge job that essentially delete a bunch of old records from this table. The strangest thing is that even after the purge job ran, the table keep growing, even though the number of records within that tables has been reduced significantly. From what I can see, the table is grabbing free blocks beyond the HWM. I thought Oracle would recycle the used blocks before attempting to use the free blocks above the HWM. Is there something I can do to rectify this issue. We're using 9iR2 with LMT and auto segment space mgmt. Thanks in advance!!