Symptom
You upgraded your Oracle database from 11.2 or 12.1 to 12.2.0.1. During the upgrade, the script "post_upgrade_tasks.sql" was executed and database parameter "_ADVANCED_INDEX_COMPRESSION_OPTIONS" was automatically set to 16. As a result of this parameter setting, all newly created indexes were compressed by default using "COMPRESS ADVANCED LOW" method.
For this compression method the Oracle license for the Advanced Compression Option (ACO) is needed. If you do not have this Oracle license for ACO, you must remove this parameter from SPFILE and rebuilt all indexes which have been compressed with "COMPRESS ADVANCED LOW" method. You followed note 2500176 and decompressed/rebuilded the indexes in SAP schema. However, some LogMiner objects belong to SYSTEM still compressed.
For example:
OWNER INDEX_NAME TABLE_NAME COMPRESSION
SYSTEM LOGMNR_I1SHARD_TS LOGMNR_SHARD_TS ADVANCED LOW
SYSTEM LOGMNRC_I1SHARD_TS LOGMNRC_SHARD_TS ADVANCED LOW
SYSTEM LOGMNRC_I1TS LOGMNRC_TS ADVANCED LOW
SYSTEM LOGMNRC_I1TSPART LOGMNRC_TSPART ADVANCED LOW
SYSTEM LOGMNRC_TS_PK LOGMNRC_TS ADVANCED LOW
SYSTEM LOGMNRC_TSPART_PK LOGMNRC_TSPART ADVANCED LOW
SYSTEM LOGMNRC_SHARD_TS_PK LOGMNRC_SHARD_TS ADVANCED LOW
Read more...
Environment
ORACLE
Keywords
_ADVANCED_INDEX_COMPRESSION_OPTIONS, Advanced Compression, LOGMNR_I1SHARD_TS, LOGMNRC_I1SHARD_TS, LOGMNRC_I1TS, LOGMNRC_I1TSPART, LOGMNRC_TS_PK, LOGMNRC_TSPART_PK, LOGMNRC_SHARD_TS_PK , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.