ORA-00044 by 11.1.0.7 patch applying
In Oracle 11.1.0.6 it is possible to set statistics_level to TYPICAL or ALL and to have at the same time timed_statistics set to FALSE. In 11.1.0.7 this is not allowed.
If you have statistics_level= TYPICAL and timed_statistics=FALSE in 11.1.0.6, by applying 11.1.0.7 patch - by starting the database after patch installation, the following error appears -
ORA-00044: timed_statistics must be TRUE when statistics_level is not BASIC
You have to set timed_statistics to TRUE. It is good to have this in mind before applying 11.1.0.7 patch.
Some time could be saved.
Leave a Reply