Looking for best practices on implementing certain parameters in 11g
1) Change the compatible parameter to 11g so that we can use Oracle auto partitions.
2) Turn on the result cache to increase the table handler performance.
Are there any known or potential pitfalls? Is there a reason why these two shouldn't be implemented at the same time? We are currently set at 10.2.0.4. We know once we go to 11, we can't go back to 10. Any info would be greatly appreciated.