Re: Inserts waiting on gc buffer busy on Node2. Waiting for Undo block of Node1

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Wed, 11 Jun 2008 09:33:31 -0500
Message-ID: <de807caa0806110733vef593c5i44c63c0c2fa63045@mail.gmail.com>


Ajay,

This sounds like a poorly designed data warehouse architecture. If that is the case, you might take a look at Tim Gorman's paper *Scaling to Infinity*-- Partitioning in Oracle Data Warehouses. http://www.evdbt.com/papers.htm
Even better, attend one of his seminars. His point is that DW's run into performance bottlenecks, and he offers suggestions on how to architect around that. This is easiest done at initial design, but you may find a way to use his suggestions on your current DW.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 11 2008 - 09:33:31 CDT

Original text of this message