1 Reply Latest reply: May 2, 2012 6:27 AM by Giuseppe Nardiello RSS

    Oracle Advanced Compression on BCO DB

    Alan Collier

      Hello

       

      Is anyone using Oracle Advanced Compression on their BCO DB?

       

      http://www.oracle.com/technetwork/database/options/compression/index.html

       

      It's invisible to the application, according to Oracle.

      It should also give a performance boost as data is compressed in memory and less IOs are generated.

      We currently use this on several very large high performance DBs.

       

      The assessment tool indicates that we'd get approx. 3:1 compression on our BCO DB.

       

      Any reason why this isn't/can't/won't be supported by BMC?

       

      Thanks

       

      Alan

        • 1. Oracle Advanced Compression on BCO DB
          Giuseppe Nardiello

          Hi Alan,

           

          This is not a supported configuration at this time, as we have no experience on whether this is suitable for the BCO architecture in production environment. That said, we might be interested in working with you and validate this configuration. Let's talk directly.

           

          thanks,


          Giuseppe

           

          In general, data de-duplication technologies can introduce CPU, memory and I/O overhead on BCO Database Server and underlying storage. Moreover, the potential impact on BCO data-warehousing activities is not known. Therefore, Oracle Advanced Compression is not a supported configuration at this time. Needless to say, our sizing recommendations (e.g. in terms of IOPS) cannot be considered valid should they use Oracle Advanced Compression.