Release Number Format
To understand the release nomenclature used by Oracle, examine the following example of an Oracle Database server labeled “Release 10.1.0.2.3”.
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 220.127.116.11.0 – 64bit Production
PL/SQL Release 18.104.22.168.0 – Production
CORE 22.214.171.124.0 Production
TNS for Linux: Version 126.96.36.199.0 – Production
NLSRTL Version 188.8.131.52.0 – Production
# component versions
select * from product_component_version;
# instance version
SELECT version FROM v$instance;