Early Benchmarks: Using Advanced Compression with Apps 12

Our recent article about using Advanced Compression with the E-Business Suite has generated a lot of excitement.  This 11gR1 database option has a lot of potential, with its dual benefits of database size reduction and application speed increases.  Our Applications Performance Group is planning to do some formal benchmarks of this technology with the E-Business Suite soon, but it looks like someone's beaten them to the punch and published some quantitative comparisons for a simple testcase.

Hans van Hoogstraten is a Technical Specialist at OraOne, an Oracle Partner in the Netherlands.  Hans just did some simple tests of Advanced Compression with Oracle E-Business Suite Release 12's Vision database.  He applied Advanced Compression to a copy of the gl.gl_balances table (6.4 million rows, ~650 MB) and ran some simple benchmarks. 

The results were impressive even for this simple test scenario:

  • 70% reduction in disk space
  • 71% reduction in I/O from logical reads
  • 66% increase in running the Cumulative Balance Sheet report

Hans has written up this benchmark test here:

A tip of the hat to Hans for being the first to post a crisply-documented benchmark.  If anyone else has data that they'd like to share with our readers, feel free to post a URL here or drop me an email.

Related Articles

Comments:

Hi

Has the Applications Performance Group published their formal benchmarks with the E-Business Suite?

I have been waiting for it for many months, but still cannot find it.

Thanks.
Regards
Jimmy

Posted by jimmy on January 03, 2010 at 03:32 PM PST #

Hi, Jimmy,

They haven't completed their formal whitepaper yet. But if you're looking for a sneak preview of their results, I believe that they referenced it lightly in their OpenWorld performance tuning session:

Tuning the Oracle E-Business Suite Environment (OpenWorld 2009 Recap) - http://blogs.oracle.com/stevenChan/2009/11/ebs_tuning_oow09.html

Regards,
Steven

Posted by Steven Chan on January 04, 2010 at 02:47 AM PST #

Do you know of any customers using Advanced Compression with Oracle BI Applications - Financial Analytics?

Posted by guest on April 15, 2013 at 06:15 AM PDT #

Hi, Guest,

I'm sure that there are, but I don't have much visibility into customer references for OBIA (I work in the E-Business Suite division). I'd recommend asking your Oracle account manager to help locate references or case studies for that combination.

Regards,
Steven

Posted by Steven Chan on April 16, 2013 at 09:58 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today