Oracle DBA, How To, Error, Cause and Action

ORA-04940: unsupported optimization of Oracle binary, check alert logfor more info

ORA-04940: unsupported optimization of Oracle binary, check alert log for more info




Cause: ORACLE binary has been optimized with unsupported options or a required option has not been used.




Action: Check the documentation for a list of supported and required flags for the optimizing utility that you used to optimize ORACLE. Shutdown the instance, optimize ORACLE again with supported combination of options and restart the instance.