How to fix the Oracle error ORA-36236: (XSANALYZ06) the AW format must be 11.0.0.0 or higher to use the ANALYZE command?

In this post, you’ll learn more about the Oracle ErrorORA-36236: (XSANALYZ06) the AW format must be 11.0.0.0 or higher to use the ANALYZE command with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36236: (XSANALYZ06) the AW format must be 11.0.0.0 or higher to use the ANALYZE command

Reason for the Error ORA-36236: (XSANALYZ06) the AW format must be 11.0.0.0 or higher to use the ANALYZE command

The AW version is less than 11.0.0.0

How to fix the Error ORA-36236: (XSANALYZ06) the AW format must be 11.0.0.0 or higher to use the ANALYZE command ?

You can fix this error in Oracle by following the below steps

Make sure the compatible mode is 11.0.0.0 or higher and upgrade the AW