> I was AMAZED how poorly Oracle performed in one certain use case (real time aggregation of a relatively large hierarchial database)

Out of interest, what kind of hierarchial database was this? Something like this?

http://explainextended.com/2009/09/28/adjacency-list-vs-nest...