Oracle version View and version number description

http://blog.163.com/magicc_love/blog/static/185853662201210194592757/

SELECT * from v$version; or select banner from sys.v_$version;  results as follows:    banner 1 Oracle Database 10g Ente Rprise Edition Release 10.2.0.1.0-prod 2 PL/SQL Release 10.2.0.1.0-production 3 CORE 10.2.0.1.0 PRODUCTION&N Bsp;4 TNS for 32-bit windows:version 10.2.0.1.0-production 5 Nlsrtl Version 10.2.0.1.0-production   such as: Oracle 9.0.1.1.2     9: Version number    0: New feature version number    1 (first): Maintenance version number    1 (second): Normal patch Setup number    2: Extraordinary platform patch settings number   oracle version number, first look at 11g a version number description:    Note:        & nbsp After Oracle version 9.2, Oracle's maintenance release number is changed at the second digit bit. And before that is in the third digit digit.    1. Major Database release number         The first digit, which represents a new version of the software, also marks some new features. such as 11g,10g.   2. Database Maintenance release number         second digit bit, which represents a maintenance Release level, may also contain some new features.   3. Fusion Middleware Release number         Third digit, which responds to the version number of Oracle Middleware (Oracle Fusion Middleware).   4. Component-specific release number         fourth digit, primarily for the release level of a component. Different components have different numbers. such as Oracle's patch package.   5. Platform-specific release number         Fifth digit bit, this digital bit identifies a version of the platform. Usually represents a patch number.    6. How to view version information:   (1) View v$version  sql> select * FROM v$version;  banner  ----- -----------------------------------------------------------  oracle Database 10g Enterprise Edition Release 10.2.0.4.0-prod  pl/sql release 10.2.0.4.0-production  core    10.2.0.4.0 & nbsp    production  tns for linux:version 10.2.0.4.0-production  nlsrtl Version 10.2.0.4.0- production  sql>   (2) product_component_version view   SQL> COL PRODUCT FORMAT A40   SQL> Col VERSION FORMAT a15  sql> Col STATUS FORMAT a15   sql> SELECT * from product_component_version;  product       & nbsp          version         status  ------------------------------- ---------------------------------------  nlsrtl                 &NBSP ;        10.2.0.4.0      production  oracle Database 10g Enterprise Edition &N Bsp 10.2.0.4.0      prod  pl/sql                   &NBSP ;         10.2.0.4.0      production  tns for Linux:       &NBSP ;              10.2.0.4.0      Production  SQL>    (3) dba_registry   sql> select Comp_name,version,status from Dba_registry;  comp_ NAME                     version         status  ------------------- -----------------------------------------  oracle Enterprise Manager      10.2.0.4.0      valid  spatial                        1 0.2.0.4.0      valid  oracle intermedia              10.2.0.4 .0      valid  olap Catalog                   10.2.0 .4.0      valid  oracle XML Database            10.2.0.4.0   & nbsp  valid  oracle Text                    10.2.0.4.0      valid  oracle Expression Filter       10.2.0.4.0      valid & Nbsp;oracle Rule Manager &nbsp          10.2.0.4.0      valid  oracle Workspace Manager     & nbsp 10.2.0.4.3      valid  oracle Data Mining             10.2.0.4.0 &N Bsp    valid  oracle Database Catalog views  10.2.0.4.0      VALID   Oracle Database Packages and T 10.2.0.4.0      valid  ypes  jserver JAVA Virtual Machi NE   10.2.0.4.0      valid  oracle XDK               &NBS P     10.2.0.4.0      valid  oracle Database Java Packages  10.2.0.4.0   &NBSP ;  valid  olap Analytic Workspace        10.2.0.4.0      valid & Nbsp;oracle OLAP API                10.2.0.4.0      VALID &NBS P Sql> &nBSP; (4) v$option view          This view is based on the underlying x$option table creation, documenting the database options and features. According to different versions, such as Standard Edition, Enterprise Edition, Personal Edition. Some options require a license to be used, such as RAC,DG, partition tables, etc.   SQL> Col PARAMETER format a40  sql> select * from v$option;      PARAMETER                                V alue  -------------------------------------------------------------------------------   Partitioning                           true & Nbsp;objects                               &NBS P  true  real application Clusters                FALSE   Advanced replication                     true  bit-mapped Inde Xes     &NBSp                 true  connection multiplexing       &NBSP ;          true  connection pooling               &NBS P       True  database queuing                   &NBSP ;     True  incremental Backup and recovery          TRUE   instead-of triggers                      true  parallel b Ackup and recovery             True  parallel execution       &NBSP ;               True  parallel load             & nbsp              true  point-in-time tablespace recovery       &NB Sp True &nBsp Fine-grained access control              true  proxy authentication/ Authorization       True  change Data Capture               &N Bsp      true  plan stability                     & nbsp     True  online Index Build                     &NB Sp True  coalesce Index                           True  managed Standby                         true  materialized View rewrite                TRUE   Materialized view warehouse Refresh      true  database resource manager       &NB Sp        true  spatial                          / nbsp      true  visual Information retrieval             TRUE &NBS P Export Transportable tablespaces         true  transparent application Failover   &NBS P     True  fast-start Fault Recovery                true & nbsp Sample Scan                              TRUE&N Bsp; duplexed backups                         true & nbsp Java                                 &NBSP ;   True  olap Window Functions                    TRUE&NBS P;  block Media Recovery                     True  fine-gra ined Auditing                    true  application Role                         true  enterprise User Security &NB Sp               true  oracle Data Guard           &NBS P            true  oracle Label Security             & nbsp      FALSE  OLAP                       &NB Sp             true  table compression             &NBS P          true  join index                 &NBSP ; &nBsp           true  trial Recovery                           True  data Mining                 &NB Sp            true  online redefinition             &NB Sp        true  streams Capture                          true  file Mapping                   &NB Sp         True  block change Tracking                    true  flashback Table                          true  flashback Database                     &NBS P TRUE  data Mining scoring Engine               False  transparent Data Encryption              true  backup encryption         & nbsp              true  unused Block Compression         &NBSP ;       true  oracle Database Vault                    false  real Application Testing                 True  s Ql>