This discussion is archived
7 Replies Latest reply: Jun 21, 2012 7:15 AM by 428027 RSS

planning to implement compression for our app on exadata

user1779355 Newbie
Currently Being Moderated
We are planning to implement compression for our app tables on exadata.

What tables should we compress?. Having size> 2GB or having 10 mill rows or what? Also since the app does not use bulk loading and there were updates to app tables and it will be cumbersome it was decided to use oltp compression. Any drawbacks to using oltp compression(with dml activity). Also should we shrink the objects(tables and indexes) before we implement compression?

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points