Chikkodi is right its the hardware that is the limit.
I am putting together a cluster of HP Superdomes and everytime I look at the numbers I just think this is one HUGE data warehouse.

Oracle isn't the limiter its the size of your budget and the hardware that you decide to purchase.