-
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
sumit
-
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
sumit
-
-
Hi Pando
what is the harm of having a very large freelist for a segment? How it should be?
Regards
sumit
-
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|