I recently upgraded to 11.2.0.2 from 11.1.0.7. Immediately after the upgrade, I noticed a spike in our redo generation. I also noticed tables with names like DBMS_TABCOMP_TEMP_UNCMP and DBMS_TABCOMP_TEMP_CMP. What are those tables doing in my production schemas and how did they get there? After digging, I was able to find out that these are created by the new 11gR2 Compression Advisor. During the nightly maintenance window, a scheduled job will look at your tables and take a subset of data and load into an uncompressed table (UNCMP). It will then compress your data (CMP) and determine the compression ratio based on your actual data. If the compression ratio is above a certain threshold, the advisor recommends the table for compression. After the Compression Advisor is done, the tables are deleted.
The problem is that the Compression Advisor generates a ton of redo! This has been noted as unpublished bug 8896202. More information can be found on Metalink Note 1284972.1 if you are interested.
I won’t be using the Compression Advisor so I’d like to turn off the nightly job. Unfortunately, the job is part of the Space Advisor and I cannot turn off the Compression Advisor on its own. Well the redo generation rate is simply too high and I guess I can live without the Space Advisor too, so off it goes:
Also see to it that you have the pill only with water and if at all you try generic viagra tab look at here now consuming it with other food items then you should opt for what is the best and if the distributors selling this are authentic or not. For some men, ED medication can help with BPH symptoms, therefore, you bulk generic viagra are able to take care of their health. The clinical symptoms of type 2 and type III are similar, there are many pain and abnormal urination, viagra cost in canada and even sexual dysfunction. Are you a man who is suffering from erectile dysfunction can also find it helpful to control generic viagra store their erections with size enhancement. SQL> exec dbms_auto_task_admin.disable(client_name=>'auto space advisor',operation=>null,window_name=>null);
PL/SQL procedure successfully completed.
I see that an enhancement request has been filed to decouple the Compression Advisor from the Space Advisor.
