Kevin Kempf's Blog

March 8, 2010

Advanced Compression with 11i, follow up impressions

Filed under: 11g, 11i, advanced compression — kkempf @ 9:31 am

We’ve been running Advanced Compression  for three week now without incident, and I have to say, things look impressive.

  • IO is way down (most of the relevant objects residing in the buffer cache)
  • CPU is up slightly (compress/uncompress overhead, we presume)
  • Performance is as good as or better than I can ever recall within the professional forms

As of today, I have only a handful of tables compressed:

SQL> select count(*) from all_tables where compression = 'ENABLED';

 COUNT(*)
----------
 55

Yet this is the most telling indicator I can show you, with only these 55 objects compressed:

Advertisements

Create a free website or blog at WordPress.com.