Hello All,
I am using Oracle 11g R2 on AIX.
In My OEM, and in the segment advisor recommendations, I got the below SQL query:
alter table tablename compress for oltp
alter table move
What benefits can I get from the above query? and does it have any disadvantage ?
If i compress my table, do i face any degradation in performance ?
While performing the compress? is there any lock on the table ? does it affect already running queries on this table?
Regards,