Alert Log Reports ORA-02097 Using "alter system set statistics_level" Command
(Doc ID 1428543.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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