Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Oracle compression with SWPM

Hello All,

I would like to know the recommendations and any suggestions for enabling Tablespace compression during the installation of SAP using SWPM.

Details

Install ERP 6.0 SR3 with Kernel 7.21 on Linux x86_64 OS with Oracle 11.2.0.4

Compression can be enabled by selecting Advanced DB configuration during SAP installation.

I found the procedure of implementing compression after system build is quite tedious, so utilizing this option .

Compression can be enabled only for SAP Appln tablespaces like PSAPSR3/PSAPSR3700/PSAPSR3USR right?

I have already glanced thru the OSS notes for ACO/Compression for SAP Systems/FAQ on Compression, pre-requisites are met I believe:

Oracle 11.2.0.4 /SAP Kernel release 721 meet the pre-requisites.

Cannot be enabled for Oracle SYSTEM/SYSAUX tablespaces.

This procedure would implement index and oltp table compression by default right?

Anda are there any manual parameters need to be amended right after the installation?

Sanity checks/monitoring need to be performed after installation?

Are there any disadvantages by enabling compression during the installation.?

Please share your real time experiences and thoughts..

Thanks in advance.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question