-
Weird behavoir in Oracle 9i
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!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|