Skip to Content

Oracle 11g Advanced Compression for SAP support

Hello community,

SAP note 1436352 says that complete DDIC support of compression attributes starts from SAP_BASIS 7.00 SP21.

I am not able to identify which features are missing in the previous SP.  I think that no problem should arise with the compression of the DB of an SAP system lower than SP21, what could be possible drawbacks in this scenario?

Thanks,

Valerio

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 18, 2012 at 12:49 PM

    Hello Valerio,

    I have compressed several SAP systems and didn't care for SAP DDIC support for Oracle Advanced Compression. Since the feature is transparent, it simply works.

    SAP could be a little bit more specific in SAP note 1436352, I agree. I believe they mean things like in table DDSTORAGE, the compressed tables have a feature PARNAME='COMPR_CLAUSE' so the SAP DDIC is also aware that a table is compressed.

    Regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      @Michael: Applying a complete SP stack is a separate activity on its own, just think about SPDD and SPAU adjustments (and subsequest testing) in highly customized environments, so I would like to avoid the effort required.

      @Mark: I completely agree with you, SAP could be more specific.

      Thanks for your help,

      Valerio

  • avatar image
    Former Member
    Apr 18, 2012 at 12:49 PM

    This simply means that SAP does not recommend using compression with a lower level. Things that might not work are for example:

    - DBACOCKPIT does not show if a segment is compressed or not

    - BRtools don't allow the use of compression

    - SE11/SE14 does not show the table properties correctly

    It might even be that some programs won't work properly with compression. The best thing in your case certainly is to consider applying a current support package stack. This never hurts and you don't have to wonder about problems you might run into (especially when SAP has fixed them already).

    Cheers Michael

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 23, 2012 at 07:24 AM

    Hi,

    you can sefely compress yor DB, even if SAP Sytem is running on a lower SP Stack.

    You just could not see compression attributes in the SAP Dictionary transactions, like SE11/12.

    Regards

    Leo

    Add comment
    10|10000 characters needed characters exceeded