← Monitoring
Oracle · Monitoring
How to check the Oracle Database version
Show every component version banner from V$VERSION to identify the exact Oracle build.
Tested on11g12c18c19c21c23ai26ai
Simplest possible query, but usually the first thing support asks for. Shows the full banner for the RDBMS and every optional component installed.
SELECT * FROM v$version;monitoringversionv$version