_exadata_feature_on system parameter must be altered on spfile, run this:

SQL> alter system set “_exadata_feature_on”=true scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1610609920 bytes
Fixed Size 9135360 bytes
Variable Size 520093696 bytes
Database Buffers 1073741824 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
SQL> EXEC DBMS_AUTO_INDEX.CONFIGURE(‘AUTO_INDEX_REPORT_RETENTION’, ‘60’);

PL/SQL procedure successfully completed.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store