Alert Log Reports ORA-02097 Using "alter system set statistics_level" Command.pdf

897

2页

3次

2021-03-13

免费下载

2020/8/26 Document 1428543.1

https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state=uadl5wyia_29&id=1428543.1 1/2

Alert Log Reports ORA-02097 Using "alter system set statistics_level" Command (Doc ID

1428543.1)

In this Document

Symptoms

Cause

Solution

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.2 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.

SYMPTOMS

When trying to change the statistics level using an alter system command as follows

SQL> alter system set STATISTICS_LEVEL = 'ALL';

The command works successfully but the following errors are reported in the alert log file:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-00439: feature not enabled

Could not change the status of MTTR Advice because of error 2097

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;

CAUSE

This is expected behavior when FAST_START_MTTR_TARGET feature is disabled (FAST_START_MTTR_TARGET=0).

When changing the STATISTICS_LEVEL parameter at system level, all the advisors that are affected by this parameter are

restarted. As the MTTR Advisor is not started/enabled the errors are raised because its statistics level cannot be changed.

SOLUTION

1. Just ignore these errors

- OR -

2020/8/26 Document 1428543.1

https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state=uadl5wyia_29&id=1428543.1 2/2

2. Enable FAST_START_MTTR_TARGET by setting the parameter to a non-zero value

Didn't find what you are looking for?

of 2

免费下载

关注