Re: RAC and FREELISTS/FREELISTGROUPS

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Wed, 5 Oct 2011 13:54:33 +0530
Message-ID: <CAJsOtB4qX92KekAFEdQEXY6SrwH0RAC1MVuZ2JxWVb+qQaP3WA_at_mail.gmail.com>

sorry Jed
Quote
The current database has dictionary managed tablespaces that were created so that some objects could be created using FREELISTS and FREELISTGROUPS to resolve performance issues. Exact knowledge of what those were doesn't exist anymore; however, I believe it is related to notes I've seen regarding "high DML tables and a tradeoff between buffer busy waits and DML contention". From what I'm reading 11gR2 has done a lot to fix this issue, and unfortunately we don't have an environment to truly test beforehand. UnQuote

something is missing..not at all digestable.. was your four node rac db built using 10204 or was it upgraded from previous versions(check the compatible parameter), if later is true docs or info must be present...
if previous is true then there should be valid reasons for it..the concerned dba and Project Lead or architect must have thought about it..and in that case they can not be just becuase
Quote
"I believe it is related to notes I've seen regarding "high DML tables and a tradeoff between buffer busy waits and DML contention"." UnQuote
thanks and take care..subodh

On 5 October 2011 02:46, Walker, Jed S <Jed_Walker_at_cable.comcast.com> wrote:

> We have a 10.2.0.4.0 RAC database that I'm currently building a new
> 11.2.0.3.0 RAC for. We will migrate to it one schema at a time using Data
> Pump.
> The current database has dictionary managed tablespaces that were created
> so that some objects could be created using FREELISTS and FREELISTGROUPS to
> resolve performance issues. Exact knowledge of what those were doesn't exist
> anymore; however, I believe it is related to notes I've seen regarding "high
> DML tables and a tradeoff between buffer busy waits and DML contention".
> From what I'm reading 11gR2 has done a lot to fix this issue, and
> unfortunately we don't have an environment to truly test beforehand.
>
> Any knowledge and advice would be greatly appreciated.
>
>
>
> - Jed
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================


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

Received on Wed Oct 05 2011 - 03:24:33 CDT