2 Replies Latest reply: Jun 27, 2013 5:33 PM by marksmithusa RSS

    Exadata - Any Functionality Change Between V2/X3 and the ESS/RDBMS?

    marksmithusa

      All,

       

      We are currently running a V2 quarter-rack on 11.2.0.2 BP7 and 11.2.2.3.2 ESS. We're moving to a X3 quarter-rack shortly which will run whatever the latest and greatest versions of RDBMS/GI/ESS are.

       

      On our current Production environment, we make use of HCC and discovered that with bitmap indexes (of which we have plenty) it was necessary to disable the index, perform the HCC compression on the table and then rebuild the index afterwards.


      Obviously, a very intensive operation when we have HUGE indexes.


      Does anyone know if this behavior the same in 11.2.0.3 RDBMS/latest ESS? Are we still required to disable the indexes before we perform HCC on the table or have the relationship between HCC and bitmap indexes chilled a little bit?


      Mark