Table Compressions

Oracle 11g extends compression for OLTP data that support DML (insert, update, delete) operation.  According to Oracle, compression technology is very efficient and could reduce space consumption by 50 to 75 %.  Write performance penalty is negligible and read performance is improved due to few I/Os and enhanced memory efficiency.


SQL> create table TRAX_OWNER.tab_comp (c1 number, c2 varchar2(30)) COMPRESS for OLTP;

Table created.


SQL> alter table TRAX_OWNER.tab_seg COMPRESS for OLTP;

Table altered.

No comments:

Post a Comment