Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

ORA-00044: timed_statistics must be TRUE when statistics_level is not BASIC

edited Feb 19, 2016 4:14AM in Database Install/Upgrade/Opatch (MOSC) 9 commentsAnswered

Hi Team,

              Getting below error message updated in alert log even though the timed_statistics and statistics_level is set appropriate.

SQL> select name, value from v$parameter where name in ('statistics_level','timed_statistics');

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
timed_statistics
TRUE

statistics_level
TYPICAL

ORA-00604: error occurred at recursive SQL level 1

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

ORA-00044: timed_statistics must be TRUE when statistics_level is not BASIC

Need your quick assistance.

Regards,

Ram.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center