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

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

Email: dvd.dba@gmail.com

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

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

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

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请