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>
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-lReceived on Wed Jun 11 2008 - 09:33:31 CDT