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/