← 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