当前位置:  数据库>oracle

dba_registry 和 v$option 与 Oracle 特新及组件

    来源: 互联网  发布时间:2017-04-04

    本文导语: 一.  先看官网对这2个视图的说明   1.1 V$OPTION        This view lists database options and features. Typically, although not always, options must be separately purchased and installed, whereas features come with the product and are enabled based on the product that is running (St...

一.  先看官网对这2个视图的说明

 

1.1 V$OPTION

       This view lists database options and features. Typically, although not always, options must be separately purchased and installed, whereas features come with the product and are enabled based on the product that is running (Standard Edition, Enterprise Edition, or Personal Oracle). If you want to see a list of all installed options for the database, use the DBA_REGISTRY view. See "DBA_REGISTRY".

Column

Datatype

Description

PARAMETER

VARCHAR2(64)

Name of the option (or feature)

VALUE

VARCHAR2(64)

TRUE if the option (or feature) is installed

 

1.2 DBA_REGISTRY

       DBA_REGISTRY displays information about the components loaded into the database.

Related View

       USER_REGISTRY displays information about the components loaded into the database that are owned by the current user.

Column

Datatype

NULL

Description

COMP_ID

VARCHAR2(30)

NOT NULL

Component identifier

COMP_NAME

VARCHAR2(255)

 

Component name

VERSION

VARCHAR2(30)

 

Component version loaded

STATUS

VARCHAR2(11)

 

Component status:

·         INVALID

·         VALID

·         LOADING

·         LOADED

·         UPGRADING

·         UPGRADED

·         DOWNGRADING

·         DOWNGRADED

·         REMOVING

·         REMOVED

MODIFIED

VARCHAR2(20)

 

Time when the component was last modified

NAMESPACE

VARCHAR2(30)

NOT NULL

Component namespace

CONTROL

VARCHAR2(30)

NOT NULL

User that created the component entry

SCHEMA

VARCHAR2(30)

NOT NULL

User that contains the objects for the component

PROCEDURE

VARCHAR2(61)

 

Validation procedure

STARTUP

VARCHAR2(8)

 

Indicates whether the component requires a startup after the upgrade (REQUIRED) or not

PARENT_ID

VARCHAR2(30)

 

Parent component identifier

 

 

二.  说明

 

通过上面的2个说明,可以看出:

       (1)v$option 视图显示的DB 所有的选项或者特性。 这些特性需要单独的购买和安装。

       (2)dba_registry 视图显示的是已经安装的组件。并且该视图的信息也比v$option 详细。

 

 

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

 

PARAMETER                                VALUE

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

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

 

PARAMETER                                VALUE

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

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

 

PARAMETER                                VALUE

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

Block Media Recovery                     TRUE

Fine-grained Auditing                    TRUE

Application Role                         TRUE

Enterprise User Security                 TRUE

Oracle Data Guard                        TRUE

Oracle Label Security                    FALSE

OLAP                                     TRUE

Table compression                        TRUE

Join index                               TRUE

Trial Recovery                           TRUE

Data Mining                              TRUE

 

PARAMETER                                VALUE

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

Online Redefinition                      TRUE

Streams Capture                          TRUE

File Mapping                             TRUE

Block Change Tracking                    TRUE

Flashback Table                          TRUE

Flashback Database                       TRUE

Data Mining Scoring Engine               FALSE

Transparent Data Encryption              TRUE

Backup Encryption                        TRUE

Unused Block Compression                 TRUE

 

54 rows selected.

 

 

 

SQL> select comp_id,comp_name,version,status from dba_registry;

 

COMP_ID    COMP_NAME           VERSION         STATUS

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

CATALOG    Oracle Database Catalog Views      10.2.0.1.0      VALID

CATPROC    Oracle Database Packages and Types  10.2.0.1.0      VALID

OWM        Oracle Workspace Manager         10.2.0.1.0      VALID

JAVAVM     JServer JAVA Virtual Machine       10.2.0.1.0      VALID

XML        Oracle XDK                      10.2.0.1.0      VALID

CATJAVA    Oracle Database Java Packages        10.2.0.1.0      VALID

EXF        Oracle Expression Filter            10.2.0.1.0      VALID

ODM        Oracle Data Mining               10.2.0.1.0      VALID

CONTEXT    Oracle Text                    10.2.0.1.0      VALID

XDB        Oracle XML Database              10.2.0.1.0      VALID

RUL        Oracle Rules Manager        10.2.0.1.0      VALID

ORDIM      Oracle interMedia            10.2.0.1.0      VALID

APS        OLAP Analytic Workspace      10.2.0.1.0      VALID

XOQ        Oracle OLAP API            10.2.0.1.0      VALID

AMD        OLAP Catalog              10.2.0.1.0      VALID

SDO        Spatial                     10.2.0.1.0      VALID

EM         Oracle Enterprise Manager     10.2.0.1.0      VALID

 

17 rows selected.


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    浙ICP备11055608号-3