一. 先看官网对这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
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
ORA-04063: package body SYS.DBMS_REGISTRY_SYS has errors
Oracle_Service_Registry uddi 安装与使用
从github上拿到的第三方插件用于删除docker registry上的镜像
【明智Wise系列 - 软件名称】Wise_Registry_Cleaner_v9.5.5.625【注册表清理优化工具】 — 清理无效注册表残留垃圾文件,注册表整理,提升系统性能 — 多账户清理,拥有管理员权限的账户可以轻松扫描清理下属所有...
wine_useful_registry_keys
ReviverSoft_Registry_Reviver_v...ReviverSoft Registry Reviver使用最先进的技术来分析电脑中的错误,侦测并移除电脑中的所有失败的软件未使用的注册表项,错误安装/卸载和优化Windows操作,提高计算机的运行速度。
Amigabit_Registry_Cleaner
注册表清理工具。Wise_Registry_Cleaner_Pro绿色版,感觉很好用。
moto手机授权文件,用于在安装anyview,moto-txt等软件时进行授权,以使其能在l7 l71等型号手机上正常使用。
本文实例讲述了Zend Framework中Zend_Registry组件用法。分享给大家供大家参考,具体如下: 1.对象注册表 入门案例: <?php require_once(Zend/Loader.php); Zend_Loader::loadClass('Zend_Registry'); $member ...
CL_Registry.ps1
Registry Victor 是专门设计来清洁和简化你的注册表以提升您的电脑效能。只要几个简单的滑鼠点击,就可以帮你清除、修复和最佳化你电脑中的 Windows registry。Windows registry 通常是造成 Windows 损毁或当机、...
注册表编辑器代码 附件: 注册表编辑.rar(110K, 下载次数:49) 分别可以在EVC和VC下编译出WM版和Windows版,这个程序是我转载的,使用了MFC的。
注册表工具Registrar_Registry_Manager,清理注册表必备
资源来自pypi官网。 资源全名:core_module_fancy_tree_registry_app-1.0.0a3.tar.gz
C++存取注册表的类,操作系统注册表C源码
Registry_Workshop_v5.0.1单文件破解版,不需要任何注册工具,下载即可使用!
资源来自pypi官网。 资源全名:core_main_registry_app-1.15.0.tar.gz
python库。资源全名:docker_registry_client_async-0.1.3.tar.gz
资源分类:Python库 所属语言:Python 资源全名:core_explore_keyword_registry_app-1.4.0.tar.gz 资源来源:官方 安装方法:https://lanzao.blog.csdn.net/article/details/101784059