Friday, October 30, 2020
    Home Oracle Internals Oracle version number detail explaination

    Oracle version number detail explaination

    Oracle version number detail explaination:

    Hi friends,

    - Advertisement -

    How to check Oracle version from installed Oracle database RDBMS?

    Using following queries we can check version of Oracle has been installed.

    SQL>select * from v$version;
    Oracle Database 10g Express Edition Release – Product
    PL/SQL Release – Production
    CORE Production
    TNS for 32-bit Windows: Version – Production
    NLSRTL Version – Production

    SQL>select * from product_component_version;
    —————————————- ———— ———-
    NLSRTL Production
    Oracle Database 10g Enterprise Edition Prod
    PL/SQL Production
    TNS for 32-bit Windows: Production

    - Advertisement -

    Interpretation and understanding of Oracle version numbering:

    First digit is Major database release number
    Second digit is Database maintenance release number
    Third digit is Application server release number
    Fourth digit is Component specific release number
    Fifth digit is Platform specific release number

    For Example take output of above sample:


    Oracle 10 <=Major database release number
    .2 <=Database maintenance release number
    .0 <=Application server release number
    .1 <=Component specific release number
    .0 <=Platform specific release number

    Thanks and regards,
    Rajiv Shah

    - Advertisement -
    - Advertisment -

    Most Popular

    Identifying important information in Big Data

    The way in which Big Data technologies have evolved in the real word enterprise goes on to show that even technologists and scientists who might have disparaged the word (Big Data) previously

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Recent Comments