Checking the Compatibility Level of Oracle Database

Use this SQL query to check that the compatibility level of your database corresponds to the value of the COMPATIBLE initialization parameter:

SQL> SELECT name, value FROM v$parameter
         WHERE name = 'compatible';