Re: Extracting 2.5 million rows
From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Mon, 11 Jan 2010 18:54:08 -0800 (PST)
Message-ID: <dca825d7-8d6c-4a8b-af25-2969814052f5_at_o28g2000yqh.googlegroups.com>
Date: Mon, 11 Jan 2010 18:54:08 -0800 (PST)
Message-ID: <dca825d7-8d6c-4a8b-af25-2969814052f5_at_o28g2000yqh.googlegroups.com>
>
> I find read only tablespaces extremely useful in the RAC environment.
> They do wonders for DLM. The GC_* waits vanish into thin air, just like
> the evil spirits. Just marvelous, especially for the DW type databases.
> It's much harder to have read only tablespaces in an OLTP database.
> --http://mgogala.byethost5.com- Hide quoted text -
>
> - Show quoted text -
You should control the urge to present humour or cynicism. Like the joke about "EXP" being illegal in Texas, stating that read only tablespaces are very useful in RAC becaue GC_% waits 'vanish' may well be misunderstood.
Hemant K Chitale Received on Mon Jan 11 2010 - 20:54:08 CST