oracle dba_registry,v$option与dba_registry

一个是动态视图，一个是数据字典，但是效用确实类似的。都是查询DB组件的安装情况。前者简单明了，后者详细。

v$option

SQL> desc v$option名称                                                                                                      是否为空?      类型

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

PARAMETER                                                                                                          VARCHAR2(64)

VALUE                                                                                                                   VARCHAR2(64)

SQL> select * from v$option;

PARAMETER                                                        VALUE

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

Partitioning                                                          TRUE

Objects                                                                TRUE

Real Application Clusters                                      FALSE

Advanced replication                                            TRUE

Bit-mapped indexes                                              TRUE

dba_registry

SQL> desc dba_registry名称                                                                                                      是否为空? 类型

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

COMP_ID                                                                                                   NOT NULL VARCHAR2(30)

COMP_NAME                                                                                                          VARCHAR2(255)

VERSION                                                                                                            VARCHAR2(30)

STATUS                                                                                                             VARCHAR2(22)

MODIFIED                                                                                                           VARCHAR2(25)

NAMESPACE                                                                                                 NOT NULL VARCHAR2(30)

CONTROL                                                                                                   NOT NULL VARCHAR2(30)

SCHEMA                                                                                                    NOT NULL VARCHAR2(30)

PROCEDURE                                                                                                          VARCHAR2(61)

STARTUP                                                                                                            VARCHAR2(8)

PARENT_ID                                                                                                          VARCHAR2(30)

OTHER_SCHEMAS                                                                                                      VARCHAR2(4000)

SQL> select * from dba_registry;

COMP_ID

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

COMP_NAME

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

VERSION                        STATUS                 MODIFIED                  NAMESPACE

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

PROCEDURE                                                     STARTUP PARENT_ID

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

OTHER_SCHEMAS

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

EM

Oracle Enterprise Manager

10.2.0.3.0                     VALID                  23-1月 -2008 17:12:54     SERVERSDO

Spatial

10.2.0.3.0                     VALID                  23-1月 -2008 21:57:12     SERVER

VALIDATE_SDO

ORDIM

Oracle interMedia

10.2.0.3.0                     VALID                  23-1月 -2008 21:57:12     SERVER

VALIDATE_ORDIM

ORDPLUGINS,SI_INFORMTN_SCHEMA