一. 先看官网对这2个视图的说明
1.1 V$OPTION
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.
二. 说明
通过上面的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 Retrieva l 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