Freelist

Hi,

I am running 32(rating) and 31 (billing) process parallel. I have configured my FREELIST to 97 for a data segment.

Do u think it is in a high end? If I set my freelist to a very high value, say 97, what is the impact on APPLICATION/DATABASE performance beside disk usage!!

Regards

Sounds very high ... freelists require space reserved in the database blocks, so they reduce the amount of available space for actual data, and decreasing the data rows-per-block means a corresponding increase in your i/o requirement to retrieve a given number of rows.

Not finding any topic as below.
1. How oracle manage Freelist and Freelist group.
2. How Does Freelist and freelist group works?

Does anybody know about any 1) Site 2) Doc 3)Presentation etc. Will appreciate.

Regards

Oracle Concepts

Hi Pando

what is the harm of having a very large freelist for a segment? How it should be?

Regards

waste space

Hi,

According to TOM

You want the number of freelists in general to be close to the number of concurrent insert|update sessions you think will be happening on a table|index (upto some reasonable number -- say 20).

Seelan