I just read an article on Oracle's table compression feature. This feature stores table data in a compressed format. It would be useful in our environment. I am curious if anyone has any experience with this feature? Is it ready for prime time?
Sure, for data warehouse fact tables it's very effective. For OLTP tables it's less so, partly because you need to use direct path insert to achieve compression, and partly because OLTP systems generally query individual rows.
There's a few "gotcha's" -- can't add or drop columns from them, for one thing.