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

来源：互联网发布：ppt简约排版知乎编辑：程序博客网时间：2024/04/29 01:47

一. 先看官网对这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.

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

Blog： http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

DBA1 群：62697716(满); DBA2 群：62697977(满) DBA3 群：62697850(满)

DBA 超级群：63306533(满); DBA4 群： 83829929 DBA5群： 142216823

DBA6 群：158654907 聊天群：40132017 聊天2群：69087192