RE: RAC and FREELISTS/FREELISTGROUPS
- From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 5 Oct 2011 15:07:05 +0000
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
