Freelist
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Freelist

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Dec 2001
    Posts
    203
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Oracle Concepts

  5. #5
    Join Date
    Dec 2001
    Posts
    203
    Hi Pando

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

    Regards
    sumit

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    waste space

  7. #7
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    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
  •  



Click Here to Expand Forum to Full Width