ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled

Error

SQL> alter system set statistics_level=basic scope=spfile;
alter system set statistics_level=basic scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled


Cause
Due to SGA_TARGET value is not having zero, it tuned for automatic tuning with Memory target parameter or it is any PDB database.

Solution
Fixed the issue with doing SGA_target parameter to Zero value.


SQL> alter system set sga_target=0 scope=both;
System altered.

SQL> alter system set statistics_level=basic;
System altered.