Welcome 微信登录

首页 / 数据库 / MySQL / dba_registry 和 v$option 与 Oracle 特新及组件

一.  先看官网对这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".
ColumnDatatypeDescription
PARAMETERVARCHAR2（64）Name of the option （or feature）
VALUEVARCHAR2（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.
ColumnDatatypeNULLDescription
COMP_IDVARCHAR2（30）NOT NULLComponent identifier
COMP_NAMEVARCHAR2（255） Component name
VERSIONVARCHAR2（30） Component version loaded
STATUSVARCHAR2（11） Component status:·         INVALID·         VALID·         LOADING·         LOADED·         UPGRADING·         UPGRADED·         DOWNGRADING·         DOWNGRADED·         REMOVING·         REMOVED
MODIFIEDVARCHAR2（20） Time when the component was last modified
NAMESPACEVARCHAR2（30）NOT NULLComponent namespace
CONTROLVARCHAR2（30）NOT NULLUser that created the component entry
SCHEMAVARCHAR2（30）NOT NULLUser that contains the objects for the component
PROCEDUREVARCHAR2（61） Validation procedure
STARTUPVARCHAR2（8） Indicates whether the component requires a startup after the upgrade （REQUIRED） or not
PARENT_IDVARCHAR2（30） Parent component identifier
  二.  说明 通过上面的2个说明，可以看出：       （1）v$option 视图显示的DB 所有的选项或者特性。 这些特性需要单独的购买和安装。       （2）dba_registry 视图显示的是已经安装的组件。并且该视图的信息也比v$option 详细。  SQL> select * from v$option; PARAMETER                                VALUE---------------------------------------- ---------------------------------------Partitioning                             TRUEObjects                                  TRUEReal Application Clusters                FALSEAdvanced replication                     TRUEBit-mapped indexes                       TRUEConnection multiplexing                  TRUEConnection pooling                       TRUEDatabase queuing                         TRUEIncremental backup and recovery          TRUEInstead-of triggers                      TRUEParallel backup and recovery             TRUE PARAMETER                                VALUE---------------------------------------- ---------------------------------------Parallel execution                       TRUEParallel load                            TRUEPoint-in-time tablespace recovery        TRUEFine-grained access control              TRUEProxy authentication/authorization       TRUEChange Data Capture                      TRUEPlan Stability                           TRUEOnline Index Build                       TRUECoalesce Index                           TRUEManaged Standby                          TRUEMaterialized view rewrite                TRUE PARAMETER                                VALUE---------------------------------------- ---------------------------------------Materialized view warehouse refresh      TRUEDatabase resource manager                TRUESpatial                                  TRUEVisual Information Retrieval             TRUEExport transportable tablespaces         TRUETransparent Application Failover         TRUEFast-Start Fault Recovery                TRUESample Scan                              TRUEDuplexed backups                         TRUEJava                                     TRUEOLAP Window Functions                    TRUE PARAMETER                                VALUE---------------------------------------- ---------------------------------------Block Media Recovery                     TRUEFine-grained Auditing                    TRUEApplication Role                         TRUEEnterprise User Security                 TRUEOracle Data Guard                        TRUEOracle Label Security                    FALSEOLAP                                     TRUETable compression                        TRUEJoin index                               TRUETrial Recovery                           TRUEData Mining                              TRUE PARAMETER                                VALUE---------------------------------------- ---------------------------------------Online Redefinition                      TRUEStreams Capture                          TRUEFile Mapping                             TRUEBlock Change Tracking                    TRUEFlashback Table                          TRUEFlashback Database                       TRUEData Mining Scoring Engine               FALSETransparent Data Encryption              TRUEBackup Encryption                        TRUEUnused 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      VALIDCATPROC    Oracle Database Packages and Types  10.2.0.1.0      VALIDOWM        Oracle Workspace Manager         10.2.0.1.0      VALIDJAVAVM     JServer JAVA Virtual Machine       10.2.0.1.0      VALIDXML        Oracle XDK                      10.2.0.1.0      VALIDCATJAVA    Oracle Database Java Packages        10.2.0.1.0      VALIDEXF        Oracle Expression Filter            10.2.0.1.0      VALIDODM        Oracle Data Mining               10.2.0.1.0      VALIDCONTEXT    Oracle Text                    10.2.0.1.0      VALIDXDB        Oracle XML Database              10.2.0.1.0      VALIDRUL        Oracle Rules Manager        10.2.0.1.0      VALIDORDIM      Oracle interMedia            10.2.0.1.0      VALIDAPS        OLAP Analytic Workspace      10.2.0.1.0      VALIDXOQ        Oracle OLAP API            10.2.0.1.0      VALIDAMD        OLAP Catalog              10.2.0.1.0      VALIDSDO        Spatial                     10.2.0.1.0      VALIDEM         Oracle Enterprise Manager     10.2.0.1.0      VALID 17 rows selected.Oracle 11g不能配置监听问题的解决Oracle oradebug 命令 使用说明相关资讯      Oracle教程 
  • Oracle中纯数字的varchar2类型和  （07/29/2015 07:20:43）
  • Oracle教程：Oracle中查看DBLink密  （07/29/2015 07:16:55）
  • [Oracle] SQL*Loader 详细使用教程  （08/11/2013 21:30:36）
  • Oracle教程：Oracle中kill死锁进程  （07/29/2015 07:18:28）
  • Oracle教程：ORA-25153 临时表空间  （07/29/2015 07:13:37）
  • Oracle教程之管理安全和资源  （04/08/2013 11:39:32）
本文评论 查看全部评论 （0）
表情： 姓名： 字数