« What's Mean "reliable message"? | Blog首页 | DBA警世录:使用ASM应当具备充分认识 »
Oracle Release Number Format含义
链接:https://www.eygle.com/archives/2008/02/oracle_release_number.html
长时间以来对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 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
历史上的今天...
>> 2018-02-23文章:
>> 2011-02-23文章:
>> 2010-02-23文章:
>> 2009-02-23文章:
>> 2006-02-23文章:
>> 2005-02-23文章:
By eygle on 2008-02-23 22:53 | Comments (0) | FAQ | 2700 |