Solution : https://service.sap.com/sap/support/notes/1109743 (SAP Service marketplace login required)
Summary :
This SAP Note addresses excessive disk space utilization due to database indexes by recommending the implementation of Index Key Compression for B*Tree indexes. Available from Oracle Release 10.2 onwards, this solution does not apply to Bitmap Indexes. The note specifies the technical prerequisites such as ensuring adequate space in the PSAPTEMP Temporary Tablespace and the target tablespace. Key Compression replaces repetitive column values with shorter tokens, maximizing space efficiency. Advantages include up to 75% space reduction and improved database throughput, albeit with increased CPU consumption. The note also includes instructions for using provided scripts and a PL/SQL package to facilitate index compression.
Key words :
improving buffer cache quality higher cpu consumption, sqlplus sapsr3/sap start glpca_ix_compin addition, rebuild online compress 2 parallel 4 pctfree 1 storage, sqlplus sapsr3/sap start ind_comphow, sqlplus sapsr3/sap set serveroutput, database throughput early customer experiences, sqlplus sapsr3/sap start ix_comp_typical_online, small space savings high uniform, offline version rebuilds indexes faster, make index key compression work
Related Notes :
| 1464156 | Support for index compression in BRSPACE 7.20 |
| 1436352 | Oracle Database 11g Advanced Compression for SAP Systems |
| 1289494 | FAQ: Oracle compression |
| 912620 | FAQ: Oracle indexes |
| 828268 | Oracle Database 10g: New functions |
| 701235 | Usage of Oracle compression and BW |
| 105047 | Support for Oracle functions in the SAP environment |