Release Number Format 和 几个有用视图

Release Number Format和几个有用视图

长时间以来对Oracle的Release命名法有些模糊，今天查了一下资料记录下来。下面以Oracle Release9.2.0.1.0为例，说明Oracle的release命名法，如下所示：

Example of an Oracle Release Number

Major Database Release Number

This is the most general identifier. It represents a major new edition (or version) of the software that contains significant new functionality.

Database Maintenance Release Number

This digit represents a maintenance release level. Some new features may also be included.

Application Server Release Number

This digit reflects the release level of the Oracle9iApplication Server (Oracle9iAS).

Component Specific Release Number

This digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.

Platform. Specific Release Number

This digit identifies a platform. specific release. Usually this is a patch set. Where different platforms require the equivalent patch set, this digit will be the same across the effected platforms.

Note:Starting with release 9.2, maintenance releases of Oracle are denoted by a change to the second digit of a release number. In previous releases, the third digit indicated a particular maintenance release.

下面几个有用视图可用来检查你的数据库当前版本：

V$OPTION

This view lists options that are installed with the Oracle server.

V$option是指dbms安装的组件。

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

EnterpriseUser Security                TRUE

Oracle Data Guard                       TRUE

Oracle Label Security                   FALSE

OLAP                                    FALSE

Heap segment compression                TRUE

Join index                              TRUE

Trial Recovery                          TRUE

Oracle Data Mining                      FALSE

Online Redefinition                     TRUE

Streams                                 TRUE

File Mapping                            TRUE

47 rows selected.

PRODUCT_COMPONENT_VERSION

PRODUCT_COMPONENT_VERSIONcontains version and status information for component products.

Product_component_version指rdbms的产品：

SQL> select * from product_component_version;

PRODUCT                                 VERSION             STATUS

---------------------------------------- -------------------- --------------------

NLSRTL                                  9.2.0.4.0           Production

Oracle9i Enterprise Edition                   9.2.0.4.0           64bit Production

PL/SQL                                   9.2.0.4.0           Production

TNS for Solaris:                            9.2.0.4.0           Production

DBA_REGISTRY

DBA_REGISTRYdisplays information about the components loaded into the database.

DBA_REGISTRY指数据库中组件的信息：

比如，建库时如选择Oracle Text，则此视图查询时也会有Oracle Text这一项。

SQL> select comp_name,version,status from dba_registry;

COMP_NAME                     VERSION             STATUS

------------------------------ -------------------- --------------------

Oracle9i Catalog Views         9.2.0.4.0           VALID

Oracle9i Packages and Types     9.2.0.4.0           VALID

Oracle Workspace Manager      9.2.0.1.0           VALID

 --The End--