This discussion is archived
2 Replies Latest reply: May 11, 2013 2:26 AM by user646034 RSS

Compression for oltp suggestion

user646034 Newbie
Currently Being Moderated
Hi All,

We are planing to compress for oltp some of the large size tables.

Size of table is more than 150 GB.

IF i will compress the tables using oltp compression. Will it affect the DML performance on those objects.

I have read some where that it will affect the DML performance.

Env details --

DB version -- 11.2.0.1
OS - IBM AIX.

Please suggest.

Thanks

Legend

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