If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

AFAIK if append hint is there then freelist doesnot come into picture and inserts will not reuse the freespace below the HWM, only the freespace available above the HWM will be used. Now how does parallesim make use of the freelist or vice versa ?

Amar"There is a difference between knowing the path and walking the path."

When you are inserting in parallel DML mode, direct-path INSERT is the default.

Now how will direct-path INSERT work? the very basic and foremost quote is

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.

Amar : I think you may now co-relate between Append/parallel/freelists

Abhay.

funky...

"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"