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

最新推荐文章于 2025-07-09 16:57:36 发布

原创最新推荐文章于 2025-07-09 16:57:36 发布 · 7.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #database #encryption #compression #manager

Oracle Basic Knowledge 同时被 2 个专栏收录

207 篇文章

订阅专栏

oracle基础知识大全

150 篇文章

订阅专栏

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

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

QQ:492913789

Email:ahdba@qq.com

Blog: http://www.cndba.cn/dave

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

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

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

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

1 条评论