Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

How to disable Advanced Compression parameters

Dear Experts,

In our Oracle 12c database current value of 'Advanced Compression' and 'Advanced Index Compression' parameters are TRUE which is default value.

SQL> select PARAMETER, VALUE from v$option where PARAMETER in ('Advanced Compression','Advanced Index Compression');

PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Advanced Compression TRUE
Advanced Index Compression TRUE

Now we required to disable these two Compression parameters. Please guide us how can we disable these.

Comments
Post Details
Added on Feb 1 2024
2 comments
117 views