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!!
05-13-2004, 02:05 AM
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.
05-13-2004, 06:08 AM
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.
05-13-2004, 07:49 AM
05-13-2004, 08:15 AM
what is the harm of having a very large freelist for a segment? How it should be?
05-13-2004, 08:59 AM
05-13-2004, 09:54 AM
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).