Oracle Version Info

Release Number Format

To understand the release nomenclature used by Oracle, examine the following example of an Oracle Database server labeled “Release”.

10 – Major Database Release Number

The first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality.

1 – Database Maintenance Release Number

The second digit represents a maintenance release level. Some new features may also be included.

0 – Application Server Release Number

The third digit reflects the release level of the Oracle Application Server (OracleAS).

2 – Component-Specific Release Number

The fourth digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.

3 – Platform-Specific Release Number

The fifth digit identifies a platform-specific release. Usually this is a patch set. When different platforms require the equivalent patch set, this digit will be the same across the affected platforms.



# Getting oracle version
SQL> select * from v$version;

Oracle Database 11g Enterprise Edition Release – 64bit Production
PL/SQL Release – Production
CORE      Production
TNS for Linux: Version – Production
NLSRTL Version – Production

# component versions
select * from product_component_version;

# instance version
SELECT version FROM v$instance;

Leave a Reply

Your email address will not be published. Required fields are marked *