Skip to Content
avatar image
Former Member

Oracle compression

Dear Expert,

I have done oracle upgrade to 11G from 10G ,,,but now client is looking for Oracle Compression also ...But i have never done this before ...i am going to do this on the Quality first ...please help me to find out the steps or any guide regarding the activity ....

Thanks

Rableen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Oct 11, 2013 at 01:53 PM

    Hi Rableen,

    In addition to the technical details, bear in mind that Oracle Compression requires an additional license if you Oracle License was not acquired throwgh SAP.

    If your customer bought the Oracle Licenses directly to Oracle He has to check the license agreement regarding compression.

    In this thread you can find detailed information:

    http://scn.sap.com/thread/1923823

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 11, 2013 at 05:23 PM

    Dear All,

    Thanks for all you helping me in the activity ......

    But my question still remains that how to proceed with the activity ,,,,

    PSAPSR3

      PSAPSR3700

              PSAPSR3FACT

              PSAPSR3ODS

              PSAPSR3USR

              PSAPTEMP

              PSAPUNDO

              SYSAUX

              SYSTEM

    From the above given table ...if i am creating the tablespace

    PSAPSR3Z

    PSAPSR3700Z

              PSAPSR3FACTZ

              PSAPSR3ODSZ

              PSAPSR3USRZ

    Then how to move the

    PSAPTEMP

              PSAPUNDO

              SYSAUX

              SYSTEM

    Tablespace to the newly created datafiles......

    Please help me more for the activity

    Rableen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 12, 2013 at 12:07 PM

    Dear All,

    I have reorganize the table ..

    ++++++++++++++++++++++++++++++++++++++

    PSAPSR3

      PSAPSR3700

              PSAPSR3FACT

              PSAPSR3ODS

              PSAPSR3USR

    ++++++++++++++++++++++++++++++++++++++

    Now how to proceed with the tablespace

    PSAPTEMP

              PSAPUNDO

              SYSAUX

              SYSTEM

    please let us know on how to proceed

    Rableen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rableen,

      The best approach (we followed for our environment) to get storage benefit out of this Oracle compression is -

      1) Allocated 60% of additional storage and created new sapdata FSs ( We had sapdata1-60 so created new FSs from 61 to 70)

      2) Prepared system for ACO enablement (We took 2hrs of downtime to increase the shared pool size and for other ACO prerequisites, downtime may not be required in your/other case)

      3) Created new TSs in new sapdata file systems (Ex:SAPSR3_NEW for SAPSR3)

      4) Migrated data from old to new tablespace by giving -C (Compression)

      5) Swapped TS names once the data is compressed and migrated to new TS

      6) Deleted old tablespace (which is 0 in size)

      7) Took a downtime and move SYSTEM, SYSAUX and PSAPUNDO to new sapdata files (Minimum downtime is required)

      8) Dropped all old sapdata file systems (sapdata1 to 60)

      9) Released the entire storage (Free LUNs) back

      Benefits of above process:

      * It require minimum downtimes

      * It migrates the TS structure from DMTS to LMTS by default (If you have any DMTS TS)

      * It gives the storage back to your environment

      Regards,

      Nick Loy

  • avatar image
    Former Member
    Jan 11, 2014 at 01:11 PM

    Hi Rableen,

    Please help me what is procedure you follow for compression for below table space (any document)

    PSAPSR3

    PSAPSR3700

    PSAPSR3FACT

    PSAPSR3ODS

    PSAPSR3USR

    how long time is required ?

    what is your tabe-space size?

    after compression what is your table-space size?

    please help.

    Thanks,

    Manas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Manas,

      Alter command just enables the OLTP compression!

      You can use -t <Table name> in brspace command to compress and migrate the data from old to new TS.

      Above commands will convert, compress, reorg and migrate the data from old to new TS.

      Post completion you can see the free space at OS.

      ACO is Oracle's feature and there is no such application restriction (It's a database feature), you can implement this on BI as well.

      Regards,

      Nick Loy

  • Oct 10, 2013 at 04:27 PM

    Hello Rableen,

    Check the following notes:

    1818320Oracle 11g Advanced Compression for LONG data restriction1436352Oracle 11g Advanced Compression for SAP Systems1289494FAQ: Oracle compression1847870Oracle 11g: Advanced Compression - Known issues and solution

    Regards,

    Eduardo Rezende

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2013 at 06:05 AM

    Hello Rableen,

    At least there are two ways getting Oracle Compression implemented:

    1. SAP System Export/Import method using R3load. The compression itself is then done during System IMPORT. Please be Aware of a longer System Import time, because the CPU needs to calculate the compression [In SAPinst/SWPM you get then the Point "OLTP Compression if you choose the exper Settings for Oracle DB :-)] This is probably the best way, because R3load "knows" the exceptions from some tables etc. .

    2. Via BR*TOOLS. Is in General supported by SAP, but you must know the exceptions and implement them on you own into the command line Statement which will be created by BR*TOOLS

    The mentioned notes from Eduardo should also help you - Read them carefully before you start :-)

    Good luck ! :-)

    Regards,

    Alex

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 11, 2013 at 08:04 AM

    Dear All,

    Thanks for your reply i have got the confusions .....I am following brspace procedure.

    In the note mentioned you have to create 30% of size of table space

    PSAPSR3

              PSAPSR3700

              PSAPSR3FACT

              PSAPSR3ODS

              PSAPSR3USR

              PSAPTEMP

              PSAPUNDO

              SYSAUX

              SYSTEM

    and having sapdata1 to sapdata9

    We have the above table space existing so we have create table space for each of the above in new datafile as

    PSAPSR3Z

              PSAPSR3700Z

              PSAPSR3FACTZ

              PSAPSR3ODSZ

              PSAPSR3USRZ

              PSAPTEMPZ

              PSAPUNDOZ

              SYSAUXZ

              SYSTEMZ

    and then run the commands.

    Rableen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rableen,

      Regarding your question about about the new tablespace ....

      Usually the compression is activated only for some tables, the bigger tables and the tables that have a better compression ratio. The approach of the note to compress and/or move all the tables from one TS to another one and after that remove the old one to reclaim the space.

      In this case you need to create a new TS for each TS that you want to move. And the new TS should be at least a 30% of the original.

      In addition, as per you TS information, your system is a SAP BW, in this case, please have a loo to this note:

      https://service.sap.com/sap/support/notes/701235