This content has been marked as final. Show 2 replies
I do not have a 10.2.0.3 environment at hand but I remember there was a bug in Oracle 11gR1 where an insert statement (with values clause and an append hint specified) use to write to a new block even when free space was available in existing blocks to fit the row.
There are no references as yet (or may be my search is not exhaustive enough) if this bug existed in lower versions as well.
You could do a test yourself to know this.
As the problem still exited after changing to database version 220.127.116.11 I opened a new thread for this topic: Empty blocks are not used for inserts
It seems that the problem occured, because OWB uses the APPEND hint by default for mappings, which is inadequate when only single rows are written to a log table.