I have to check the storage parameters for a particular table. One of the questions I have been explicitly asked is "Are there enough freelists on that table". After saying "Huh? Wot?" a few times and going and reading some books, I now know what the free list is and how it is used, but I still have no idea how to tell if there is freelist contention on the table. I know it will be caused by lots of concurrent updates and deletions so that the blocks are popping onto and dropping of the list of available blocks as space goes over pctfree/under pctused, but how do you identify this?
Currently there is the default of 1 for freelists and 1 for freelist groups.