Quote:
Originally posted by abhaysk
During direct-path INSERT operations, Oracle appends the inserted data after existing data in the table. Data is written directly into datafiles, bypassing the buffer cache. Free space in the existing data is not reused, and referential integrity constraints are ignored. These procedures combined can enhance performance.
Well ur quote from the docs says it very clearly that during parallel DML, Append is the default and free space is not reused. So you prove my point. No freelist in picture so giving a high freelist of 4 is of no use as shown by Tamil.