How to check Oracle Database version

Queries below return server version, edition and system information.

Using V$VERSION

Query

select * from V$VERSION

Columns

  • banner - string containing server information

Rows

Query returns many rows, each containing information about core Oracle component.

Sample results

Oracle 11g XE on Linux server:

Sample results

Oracle 9i on AIX server:

Sample results

Using V$INSTANCE

If you have dba privilege you can access database version information in V$INSTANCE view

Query

select version from V$INSTANCE

Columns

  • version - database version information

Rows

Query returns just one row

Sample results

Oracle 11g XE:

Sample results

Oracle 9i:

Sample results

Releases

Oracle is using release naming convention. You can translate version number to release name for contemporary releases with this table:

Version no Release name
9.0.x.x Oracle9i Database
9.2.x.x Oracle9i Database Release 2
10.1.x.x Oracle Database 10g Release 1
10.2.x.x Oracle Database 10g Release 2
11.1.x.x Oracle Database 11g Release 1
11.2.x.x Oracle Database 11g Release 2
12.1.x.x Oracle Database 12c Release 1
12.2.x.x Oracle Database 12c Release 2
18.1.x.x Oracle Database 18c
0
There are no comments. Click here to write the first comment.