Re: RAC and FREELISTS/FREELISTGROUPS

  • From: Sidney Chen <huanshengchen@xxxxxxxxx>
  • To: Mark.Bobak@xxxxxxxxxxxx
  • Date: Wed, 5 Oct 2011 14:45:28 +0800

>
>
> 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.


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


Other related posts: