Oracle DBA: February 2008 Archives

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

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

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

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

PRODUCT_COMPONENT_VERSION contains 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_REGISTRY displays 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