RE: RAC and FREELISTS/FREELISTGROUPS
- From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
- To: free <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 Oct 2011 23:40:45 -0700 (PDT)
ASSM suffer from insert contention for big tables under high DML rate while it
tries to add multiple extents. If you don't have big tables (over 50G or so)
with high DML, stay with ASSM, other wise freelists/freelist groups combination
would be better.
I'm not sure whether ASSM enhanced in 11.2, but I doubt it as the underlying
insert contention for big tables was tied to ASSM design.
Thanks,
Sai
http://sai-oracle.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
