Re: direct path write wait

On 12/27/2006 11:13:48 AM, blr_dba wrote:
> Hi,
>
> It is a DWH query, which has many outer joins. And has "order by" clause as well.
>
> The wait is because of sorts only but cant avoid sorting....

The solution is very simple. It's called EMC Symmetrix and with enough spindles and cache it will make your query run much faster. Of course, a nice little IBM 595 or HP 9000 rp8420 equipped with enough CPU power and memory, attached to EMC storage would also be helpful. The biggest mistake that companies are doing is trying to run large DW type database on a Dell box which doesn't have neither sufficient I/O bandwidth nor the CPU power. Tuning only goes that far, there is a point when you need to start throwing horsepower into the mix to get the required performance. The computer named "Deep Blue" has beaten the world champion in the game of chess. My Thinkpad, albeit from the same vendor, would probably not be able to defeat a chess master (although it regularly does so with me) because of the insufficient computing power. If you come to think of it, searching through a large database a summarizing the results is a daunting task and not every machine is up to the task.

-- 
Mladen Gogala
http://www.mladen-gogala.com

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