Alert Log Reports ORA-02097 Using "alter system set statistics_level" Command
(Doc ID 1428543.1)
Last updated on DECEMBER 26, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
When trying to change the statistics level using an alter system command as follows
The command works successfully but the following errors are reported in the alert log file:
ORA-00439: feature not enabled
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-25530: FAST_START_MTTR_TARGET is not specified
ALTER SYSTEM SET statistics_level='ALL' SCOPE=BOTH;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document