RE: Altering Freelist Groups in 10gR2 when moving to RAC from NON-RAC?

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <VIVEK_SHARMA@xxxxxxxxxxx>
  • Date: Thu, 28 Sep 2006 08:32:19 +0200


> Qs Does conversion of freelist groups to 4 needs to be done ONLY for
> Tables & Indexes which undergo INSERTs & NOT for Tables / Indexes
> which undergo UPDATEs, SELECTs, DELETEs?

To answer your question...

Free lists could be used by UPDATE and DELETE statements as well.

- When an UPDATE statement generates migrated and/or chained rows.
- When a DELETE statement frees enough space to put the block on a free

That said, the former should be avoided anyway and the later is not that
usual... Therefore, usually, the INSERT statements are the most
important factor to consider.

In any case SELECT statements don't access the free lists.


Other related posts: