eygle.com   eygle.com
eygle.com eygle

« What's Mean "reliable message"? | Blog首页 | DBA警世录:使用ASM应当具备充分认识 »

Oracle Release Number Format含义

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

Example of an Oracle Release Number




oracle release number format.jpg




















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 Oracle9i Application 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.





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



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                                     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 contains version and status information for component products.



SQL> select * from product_component_version;

PRODUCT                                  VERSION              STATUS

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

NLSRTL                                     Production

Oracle9i Enterprise Edition                      64bit Production

PL/SQL                                      Production

TNS for Solaris:                               Production




DBA_REGISTRY displays information about the components loaded into the database.


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


SQL> select comp_name,version,status from dba_registry;

COMP_NAME                      VERSION              STATUS

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

Oracle9i Catalog Views            VALID

Oracle9i Packages and Types            VALID

Oracle Workspace Manager            VALID



    >> 2018-02-23文章:
    >> 2011-02-23文章:
    >> 2010-02-23文章:
    >> 2009-02-23文章:
    >> 2006-02-23文章:
    >> 2005-02-23文章:
           Redo allocation latch介绍

By eygle on 2008-02-23 22:53 | Comments (0) | FAQ | 2700 |

CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com