Posts Tagged ‘ parallel query ’

The Core Performance Fundamentals Of Oracle Data Warehousing – Parallel Execution

April 19, 2010
By
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 »

Oracle Parallel Execution: Interconnect Myths And Misunderstandings

July 6, 2009
By
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 »