RE: RAC and FREELISTS/FREELISTGROUPS
Date: Wed, 5 Oct 2011 15:07:05 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C55F655EF_at_COPDCEXMB09.cable.comcast.com>
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_at_gmail.com]
Sent: Wednesday, October 05, 2011 12:45 AM
To: Mark.Bobak_at_proquest.com
Cc: Walker, Jed S; oracle-l_at_freelists.org
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-lReceived on Wed Oct 05 2011 - 10:07:05 CDT