Hi there,
I'm using an 11.2 oracle database. For a typical business case I have to use a table as a queue. I mean, I have to insert thousands of rows in the table and delete them afterward. the amount of inserts are the same in all turns. after a few times of consecutive insertions and deletions I felt performance degradation in doing query over the table. I know the issue of HWM of empty table. After diving into details I found the number of blocks occupied by the table is increasing after each inserts when I defined the table as compressed and is constant if it is not usinf compression. I googled the issue and I didn't find anything useful for that. I'm using compress for OLTP option and I want to tell oracle db to please use the freed up space of the table.
thanks in advance.