Best method to increase freelists

[bhatia333]

Hi Guru's
What are the best practises followed for increasing the freelists and freelist groups for a particular list of tables which are in varied tablespace?
Any help is appreciated.

Thanks in advance

[davey23uk]

why not use ASSM and forget about it

[bhatia333]

Client is reluctunt to use ASSM as they had problem once with it (not sure what as I am new). But lets say ASSM was not an option. Whats the best way to do it manually.

[tamilselvan]

See my article

http://beaconinfotechcorp.com/art_004.html

Tamil
www.beaconinfotechcorp.com

[bhatia333]

Thanks for your article Tamil. Its a good experimentation to show the effect of using different settings for freelists. But I am still not clear from this article as to the methodology that should be followed in increasing the freelists manually. Maybe I am missing something here. Please enlighten!

Thanks

[tamilselvan]

That article was written long time ago.

What you need to know is how many concurrent sessions issue insert/update/delete operations on a table and the response time acceptable by the end users.

Tamil

[ixion]

Good article, Good conclusion and recomendations at the end!