RE: RAC and FREELISTS/FREELISTGROUPS

I wish I had that book right now.
I mixed that up. The tablespaces are locally managed, but the extent management 
was made "manual" so that freelists and freelistgroups could be increased. I 
was sure I read a Burleson site that said improvements had been made in 11g for 
this issue, but I'm thinking for now I'll stick with an ASSM and an MSSM for 
the high DML tables - unless someone has some extra knowledge to impart.

Thank you to those who responded, despite being worn out from OOW.

From: Sidney Chen [mailto:huanshengchen@xxxxxxxxx]
Sent: Wednesday, October 05, 2011 12:45 AM
To: Mark.Bobak@xxxxxxxxxxxx
Cc: Walker, Jed S; oracle-l@xxxxxxxxxxxxx
Subject: Re: RAC and FREELISTS/FREELISTGROUPS


As to ASSM vs. MSSM, Jonathan Lewis looked into this when the feature was first 
introduced, (10g, I think?) and concluded that ASSM is effectively equivalent 
to 16 FREELISTS, in terms of concurrency.  I'm not aware of any changes to that 
for 11g.  You might want to check his blog.  Also, if I bump into him, I'll ask 
him to check his email when he has a chance, and weigh in on this thread.

in the Book "Cost Based Oracle Fundamentals", chapter 5 "The Clustering 
Factor",  Jonathan Lewis present a great explain between ASSM and MSSM, you may 
want to go through it.

--
http://www.freelists.org/webpage/oracle-l

Other related posts: