Yes, the datamodel sucks but it shouldn't run that slow, and it doesn't on SloanSpace.
Which makes me wonder ... are you sure that you've told Oracle to gather statistics on your tables in order to raise odds that it's generated a decent execution plan?
