How to Identifying Your Oracle Database Software Release

Oracle database Release number format:

Example of an Oracle Database Release Number 11.2.0.1.0

11->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.

2->Database maintenance release number

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

0->Fusion Middleware release number

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

1->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.

0->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.

How to check current Release Number:-

SELECT * FROM PRODUCT_COMPONENT_VERSION;

Comments

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to clear weblogic stuck threads in R12.2