oracle ture,Oracle Release Number Format含义

Oracle Release Number Format含义

长时间以来对Oracle的Release命名法有些模糊，今天查了一下资料记录下来。下面以Oracle Release 9.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;

PARAMETERVALUE

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

PartitioningTRUE

ObjectsTRUE

Real Application ClustersFALSE

Advanced replicationTRUE

Bit-mapped indexesTRUE

Connection multiplexingTRUE

Connection poolingTRUE

Database queuingTRUE

Incremental backup and recoveryTRUE

Instead-of triggersTRUE

Parallel backup and recoveryTRUE

Parallel executionTRUE

Parallel loadTRUE

Point-in-time tablespace recoveryTRUE

Fine-grained access controlTRUE

Proxy authentication/authorizationTRUE

Change Data CaptureTRUE

Plan StabilityTRUE

Online Index BuildTRUE

Coalesce IndexTRUE

Managed StandbyTRUE

Materialized view rewriteTRUE

Materialized view warehouse refreshTRUE

Database resource managerTRUE

SpatialTRUE

Visual Information RetrievalTRUE

Export transportable tablespacesTRUE

Transparent Application Failover TRUE

Fast-Start Fault RecoveryTRUE

Sample ScanTRUE

Duplexed backupsTRUE

JavaTRUE

OLAP Window FunctionsTRUE

Block Media RecoveryTRUE

Fine-grained AuditingTRUE

Application RoleTRUE

EnterpriseUser SecurityTRUE

Oracle Data GuardTRUE

Oracle Label SecurityFALSE

OLAPFALSE

Heap segment compressionTRUE

Join indexTRUE

Trial RecoveryTRUE

Oracle Data MiningFALSE

Online RedefinitionTRUE

StreamsTRUE

File MappingTRUE

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;

PRODUCTVERSIONSTATUS

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

NLSRTL9.2.0.4.0Production

Oracle9i Enterprise Edition9.2.0.4.064bit Production

PL/SQL9.2.0.4.0Production

TNS for Solaris:9.2.0.4.0Production

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_NAMEVERSIONSTATUS

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

Oracle9i Catalog Views9.2.0.4.0VALID

Oracle9i Packages and Types9.2.0.4.0VALID

Oracle Workspace Manager9.2.0.1.0VALID

By eygle on 2008-02-23 22:53 |

Comments (0) |

FAQ | 2700 |