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
Printable View
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
why not use ASSM and forget about it
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.
See my article
http://beaconinfotechcorp.com/art_004.html
Tamil
www.beaconinfotechcorp.com
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
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
Good article, Good conclusion and recomendations at the end!