v$option && dba_registry

在我们安装完数据库之后，需要对数据库组件进行一次检查，查看状态是否是可用的。在手动建库的时候，存在安装的组件不全，需要我们手动安装所需组件。这里提供查看组件的方法。

--查看系统中的组件SQL> select comp_id,comp_name,status,CON_ID from cdb_registry;COMP_ID                COMP_NAME                      STATUS             CON_ID------------------------------ -------------------------------------------------- ---------------------- ----------CATALOG                Oracle Database Catalog Views              VALID               1CATPROC                Oracle Database Packages and Types         VALID               1JAVAVM                 JServer JAVA Virtual Machine           VALID               1XML                Oracle XDK                     VALID               1CATJAVA                Oracle Database Java Packages              VALID               1APS                OLAP Analytic Workspace                VALID               1RAC                Oracle Real Application Clusters           OPTION OFF              1XDB                Oracle XML Database                VALID               1OWM                Oracle Workspace Manager               VALID               1CONTEXT                Oracle Text                    VALID               1ORDIM                  Oracle Multimedia                  VALID               1COMP_ID                COMP_NAME                      STATUS             CON_ID------------------------------ -------------------------------------------------- ---------------------- ----------SDO                Spatial                        VALID               1XOQ                Oracle OLAP API                    VALID               1APEX                   Oracle Application Express             VALID               114 rows selected.--显示数据库选项和特性SQL> col parameter for a40SQL> col value for a40SQL> select * from v$option;PARAMETER                VALUE                        CON_ID---------------------------------------- ---------------------------------------- ----------Partitioning                 TRUE                          0Objects                  TRUE                          0Real Application Clusters        FALSE                         0Advanced replication             TRUE                          0Bit-mapped indexes           TRUE                          0Connection multiplexing          TRUE                          0Connection pooling           TRUE                          0Database queuing             TRUE                          0Incremental backup and recovery      TRUE                          0Instead-of triggers          TRUE                          0Parallel backup and recovery         TRUE                          0PARAMETER                VALUE                        CON_ID---------------------------------------- ---------------------------------------- ----------Parallel execution           TRUE                          0Parallel load                TRUE                          0Point-in-time tablespace recovery    TRUE                          0Fine-grained access control      TRUE                          0Proxy authentication/authorization   TRUE                          0Change Data Capture          TRUE                          0Plan Stability               TRUE                          0Online Index Build           TRUE                          0Coalesce Index               TRUE                          0Managed Standby              TRUE                          0Materialized view rewrite        TRUE                          0PARAMETER                VALUE                        CON_ID---------------------------------------- ---------------------------------------- ----------Database resource manager        TRUE                          0Spatial                  TRUE                          0Automatic Storage Management         FALSE                         0Export transportable tablespaces     TRUE                          0Transparent Application Failover     TRUE                          0Fast-Start Fault Recovery        TRUE                          0Sample Scan              TRUE                          0Duplexed backups             TRUE                          0Java                     TRUE                          0OLAP Window Functions            TRUE                          0Block Media Recovery             TRUE                          0PARAMETER                VALUE                        CON_ID---------------------------------------- ---------------------------------------- ----------Fine-grained Auditing            TRUE                          0Application Role             TRUE                          0Enterprise User Security         TRUE                          0Oracle Data Guard            TRUE                          0Oracle Label Security            FALSE                         0OLAP                     TRUE                          0Basic Compression            TRUE                          0Join index               TRUE                          0Trial Recovery               TRUE                          0Advanced Analytics           TRUE                          0Online Redefinition          TRUE                          0PARAMETER                VALUE                        CON_ID---------------------------------------- ---------------------------------------- ----------Streams Capture              TRUE                          0File Mapping                 TRUE                          0Block Change Tracking            TRUE                          0Flashback Table              TRUE                          0Flashback Database           TRUE                          0Transparent Data Encryption      TRUE                          0Backup Encryption            TRUE                          0Unused Block Compression         TRUE                          0Oracle Database Vault            FALSE                         0Result Cache                 TRUE                          0SQL Plan Management          TRUE                          0PARAMETER                VALUE                        CON_ID---------------------------------------- ---------------------------------------- ----------SecureFiles Encryption           TRUE                          0Real Application Testing         TRUE                          0Flashback Data Archive           TRUE                          0DICOM                    TRUE                          0Active Data Guard            TRUE                          0Server Flash Cache           TRUE                          0Advanced Compression             TRUE                          0XStream                  TRUE                          0Deferred Segment Creation        TRUE                          0Unified Auditing             FALSE                         0Management Database          FALSE                         0PARAMETER                VALUE                        CON_ID---------------------------------------- ---------------------------------------- ----------I/O Server               FALSE                         0ASM Proxy Instance           FALSE                         0Exadata Discovery            TRUE                          0Data Mining              TRUE                          0Global Data Services             TRUE                          0Adaptive Execution Plans         TRUE                          0Table Clustering             TRUE                          0Zone Maps                TRUE                          0Real Application Security        TRUE                          0Privilege Analysis           TRUE                          0Data Redaction               TRUE                          0PARAMETER                VALUE                        CON_ID---------------------------------------- ---------------------------------------- ----------Cross Transportable Backups      TRUE                          0Cache Fusion Lock Accelerator        TRUE                          0Snapshot time recovery           TRUE                          0Heat Map                 TRUE                          0Automatic Data Optimization      TRUE                          0Transparent Sensitive Data Protection    TRUE                          0In-Memory Column Store           TRUE                          0Advanced Index Compression       TRUE                          0In-Memory Aggregation            TRUE                          086 rows selected.