remote dba support
More
    HomeOracle InternalsOracle version number detail explanation

    Oracle version number detail explanation

    Oracle version number detail explanation:

    Hi friends,

    - Advertisement -
    dbametrix

    How to check the Oracle version from the installed Oracle database RDBMS?

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

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

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

    - Advertisement -
    dbametrix

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

    Explained:

    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
    http://www.dbametrix.com
    http://www.dbametrix.com/remote-dba.html

    When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.

    This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.

    - Advertisement -
    dbametrix
    - Advertisment -
    remote dba services

    Most Popular