Re: Inserts waiting on gc buffer busy on Node2. Waiting for Undo block of Node1
Date: Wed, 11 Jun 2008 09:33:31 -0500
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.
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 WilliamsReceived on Wed Jun 11 2008 - 09:33:31 CDT