Oracle version View and version number description ____oracle

SELECT * from V$version;

Select banner from Sys.v_$version;
The results are as follows:
BANNER
1 Oracle Database 10g Enterprise 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
4 TNS for 32-bit windows:version 10.2.0.1.0-production
5 Nlsrtl Version 10.2.0.1.0-production

For example: 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: Special platform Patch Set number

Oracle has a lot of version numbers, first look at the 11g version number description:
Attention:

    After Oracle 9.2, Oracle's maintenance release number was changed in the second digit digit. And before that was in the third digit bit. 

Major Database Release Number

The first digit bit, which represents a new version of the software, also marks some new features. such as 11g,10g.

Database Maintenance Release Number

The second digit bit, representing a maintenance release level, may also contain some new features.

Fusion Middleware Release Number

A third digit bit that responds to the version number of Oracle Middleware (Oracle Fusion Middleware).

Component-specific Release Number

The fourth digit bit, mainly for the release level of the component. Different components have different numbers. such as Oracle's patch package.

Platform-specific Release Number

The fifth digit bit, which identifies the version of a platform. Usually represents the patch number. 

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 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 VERSION STATUS

Nlsrtl 10.2.0.4.0 Production

Oracle Database 10g Enterprise Edition 10.2.0.4.0 Prod

Pl/sql 10.2.0.4.0 Production

TNS for linux: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 10.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 VALID

Oracle Text 10.2.0.4.0 VALID

Oracle Expression Filter 10.2.0.4.0 VALID

Oracle Rule Manager 10.2.0.4.0 VALID

Oracle Workspace Manager 10.2.0.4.3 VALID

Oracle Data Mining 10.2.0.4.0 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 Machine 10.2.0.4.0 VALID

Oracle XDK 10.2.0.4.0 VALID

Oracle Database Java Packages 10.2.0.4.0 VALID

OLAP Analytic Workspace 10.2.0.4.0 VALID

Oracle OLAP API 10.2.0.4.0 VALID

Sql>

(4) V$option view

This view is based on the underlying x$option table creation, which records database options and features. According to different versions, such as Standard Edition, Enterprise Edition, Personal Edition. Some options require the purchase of relevant licenses to be used, such as RAC,DG, zoning tables, and so on.

sql> Col PARAMETER format A40

Sql> select * from V$option;

PARAMETER VALUE

Partitioning TRUE

Objects TRUE

Real application Clusters FALSE

Advanced Replication TRUE

bit-mapped Indexes TRUE

Connection Multiplexing TRUE

Connection Pooling TRUE

Database Queuing TRUE

Incremental backup and Recovery TRUE

instead-of triggers TRUE

Parallel Backup and Recovery TRUE

Parallel Execution TRUE

Parallel Load TRUE

Point-in-time tablespace Recovery TRUE

Fine-grained access Control TRUE

Proxy authentication/authorization TRUE

Change Data Capture TRUE

Plan stability TRUE

Online Index Build TRUE

COALESCE Index TRUE

Managed Standby TRUE

Materialized view rewrite TRUE

Materialized View Warehouse Refresh TRUE

Database Resource Manager TRUE

Spatial TRUE

Visual Information Retrieval TRUE

Export Transportable tablespaces TRUE

Transparent application Failover TRUE

Fast-start Fault Recovery TRUE

Sample Scan TRUE

duplexed Backups TRUE

Java TRUE

OLAP Window Functions TRUE

Block Media Recovery TRUE

Fine-grained auditing TRUE

Application role TRUE

Enterprise User Security TRUE

Oracle Data Guard TRUE

Oracle Label Security FALSE

OLAP TRUE

Table Compression TRUE

Join Index TRUE

Trial Recovery TRUE

Data Mining TRUE

Online redefinition TRUE

Streams Capture TRUE

File Mapping TRUE

Block change Tracking TRUE

Flashback Table TRUE

Flashback Database TRUE

Data Mining scoring Engine FALSE

Transparent Data Encryption TRUE

Backup Encryption TRUE

Unused block Compression TRUE

Oracle Database Vault FALSE

Real Application Testing TRUE

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