Re: RAC and FREELISTS/FREELISTGROUPS
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Wed, 5 Oct 2011 14:45:28 +0800
Message-ID: <CAM_ddu8ufHKESXYwt3heMEdN=vo0YK71g0G2=VYxr1WocDsVVA_at_mail.gmail.com>
>
>
> 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.
Date: Wed, 5 Oct 2011 14:45:28 +0800
Message-ID: <CAM_ddu8ufHKESXYwt3heMEdN=vo0YK71g0G2=VYxr1WocDsVVA_at_mail.gmail.com>
>
>
> 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-lReceived on Wed Oct 05 2011 - 01:45:28 CDT