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