partition compression - any issues
I am looking into compressing some of my old historical partitions in 10.2.0.3 database. These partitions are not updated; they are only read from via select command. I read a few articles, looks like in this situation there is no downside to compression, only the potential benefis in terms of space usage (less) and performance (faster). If anyone used it in real life, is there anything else that I should be taking into account?
thank you
Gene