A follow-up on the previous analysis: When running more elaborate tests, ROW_NUMBER() as opposed to ROWNUM seems to cause quite a heavy performance issue in more sophisticated queries, which I cannot disclose here. Maybe we should wait with any patching and benchmark various options in a real, close-to-production setup?
Cheers Lukas
