Can you post two executions plan: one with the ORDERED hint, one without it. Then we may be able to see why Oracle goes wrong.
As to scalability of the data model: I have a half-finished version of calendar that doesn't depend on acs-events anymore (PG). There is so many tables joined in this query - it's probably impossible to make it scale nicely.
