Oracle 12: How Disable COMPRESSION

[former_member275905]

Hello,

How to DISABLE COMPRESSION generally ?

We did not use RMAN.

Is it right that this DISABLED COMPRESSION:  _advanced_index_compression_options=0

sqlplus / as sysdba

alter system set "_advanced_index_compression_options"=0 scope=spfile SID= '*';

And in the file : /oracle/<SID>/12102/network/admin/sqlnet.ora

sqlnet.compression=off

If i do a:

sqlplus / as sysdba

SELECT table_name,partition_name,compression,num_rows,blocks,empty_blocks FROM user_tab_partitions;

i see "DISABLED" on all

So there is no trouble with ORACLE about License Audit for example - if there is no LICENSE for COMPRESSION ???

In SAP Note:  i see only the Value: 16

How to check if COMPRESSION was ENABLED before ?

Thanks

[Former Member · Accepted solution]

Hi

Check the sap note 2138262 and 2254866. Hope it helps

https://launchpad.support.sap.com/#/notes/2138262/E

https://launchpad.support.sap.com/#/notes/2254866

Regards

Prithviraj

[former_member275905 · Accepted solution]

thanks, but i did not see it how to disable it

[Former Member · Accepted solution]

Hi Dennis,

In Oracle Database 12c, several new features have been added to the Oracle Advanced Compression option which enhances the storage management capabilities of Oracle Database. Heat Map automatically tracks modification and query timestamps, providing detailed insights into how data is being accessed. Automatic Data Optimization (ADO) automatically moves and compresses data based on the information collected by Heat Map

Heat Map and ADO make it easy to use existing innovations in Oracle Database compression technologies

Parameter is HEAT_MAP

Read below sap note

https://launchpad.support.sap.com/#/notes/1888485

https://launchpad.support.sap.com/#/notes/2254866

PDF White Paper is attached with the above note

https://launchpad.support.sap.com/#/notes/2254836/E

Regard

Prithviraj

[former_member275905 · Accepted solution]

thanks a lot!