Parallel Execution

The Core Performance Fundamentals Of Oracle Data Warehousing – Parallel Execution

April 19, 2010
By Greg Rahn
The Core Performance Fundamentals Of Oracle Data Warehousing – Parallel Execution

Leveraging Oracle’s Parallel Execution (PX) in your Oracle data warehouse is probably the most important feature/technology one can use to speed up operations on large data sets.  PX is not, however, “go fast” magic pixi dust for any old operation (if thats what you think, you probably don’t understand the parallel...
Read more »

Tags: , , , ,
Posted in Data Warehousing, Oracle, Parallel Execution, Performance, VLDB | 8 Comments »

Oracle Parallel Execution: Interconnect Myths And Misunderstandings

July 6, 2009
By Greg Rahn
Oracle Parallel Execution: Interconnect Myths And Misunderstandings

A number of weeks back I had come across a paper/presentation by Riyaj Shamsudeen entitled Battle of the Nodes: RAC Performance Myths (avaiable here). As I was looking through it I saw one example that struck me as very odd (Myth #3 – Interconnect Performance) and I contacted him about it. After further review...
Read more »

Tags: , ,
Posted in Data Warehousing, Oracle, Parallel Execution, Performance, VLDB | 15 Comments »