This content has been marked as final. Show 4 replies
1: The fix for the fix of bug 5520732 is already solved in 11.2, so this won't help
2: This can cause performance, suboptimal plans and losing lot of features from 11.2
The third option is always the best in this case, rewrite the query. There is an error in the SQL, so fix that one. It is just one query, so it wouldn't be to hard. The group by items are possibly out of sync with the select items.
Herald ten Dam
But option 1 is also solving the problem. can you tell me the impact of option 1?
Hidden parameters should only be set upon the advice of Oracle Support. Doing do otherwise may cause unknown repercussions - it sounds like you do not have a support contract with Oracle, so are you willing to take this risk ?1 person found this helpful