Forum Stats

  • 3,851,381 Users
  • 2,263,969 Discussions
  • 7,904,691 Comments

Discussions

Oracle Advance Compression Deletion Performance issue in 11g R1

vbk
vbk Member Posts: 22
edited Apr 15, 2011 8:25AM in Advanced Compression
Hi,

We have implemented OAC in our datawarehouse environment to enable table and index compression. We tested in our Test machine and we gained almost 600GB due to advance compression without any issues and all the informatica loads are running fine. And hence we implemented the same in our production but unfortunately two sessions which are involving deletion of data are taking more time (3 times of actual timing) for completion which affects our production environment.

The tables creating issue are all non partitioned tables.

I need to know whether Oracle Advance Compression will decrease delete performance? and is there any way to disable advance compression on those particular tables?

Our environment details:

DB earlier version: 11.1.0.6
DB current version : Oracle 11.1.0.7
Applied PSU: 11.1.0.7.6
Operating system: Solaris 5.9

Syntax used for compression:

ALTER TABLE TABLE_NAME MOVE COMPRESS FOR ALL OPERATIONS;

Thanks in Advance.

Answers

This discussion has been closed.