Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fragmentation. Inserts not using free space

Rob_JDec 3 2009 — edited Dec 8 2009
Hi,

We are running Oracle version 10.2.04, and we have a tablespace with locally managed, uniform, extents with ASSM set to manual. As part of our ETL process, we delete rows one at a time in a loop and then commit every 10,000 rows. We then insert using the same method.

Can anyone think of reasons why the inserts would not use the free space from the deletion statements?

I'm going to try and run a few tests, so any recommendations for this would be appreciated.

Thanks,
Rob
This post has been answered by Robert Geier on Dec 3 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2010
Added on Dec 3 2009
#general-database-discussions
12 comments
1,150 views