V$option && Dba_registry

After we have installed the database, we need to check the database components once to see if the status is available. When manually building the library, there are components that are not fully installed and require us to manually install the required components. Here is a way to view the components.

--View the components in the system sql> select comp_id,comp_name,status,con_id from Cdb_registry; comp_id comp_name STATUS con_id------------------------------------------ ----------------------------------------------------------------------Catalog Oracle Database Catalog Vie               WS VALID 1CATPROC Oracle Database Packages and Types VALID                     1JAVAVM jserver JAVA Virtual machine VALID 1XML Oracle XDK VALID 1CATJAVA Oracle Database Java Packages VALID 1A PS OLAP Analytic Workspace VALID 1RAC Oracle Real application C                Lusters 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 rows selected.--display database options and features 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 TR           UE 0Connection multiplexing TRUE 0Connection pooling       True 0Database queuing true 0Incremental backup and recovery True 0instead-of triggers True 0Parallel backup and Recov ery 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 0M                          Anaged Standby true 0Materialized view rewrite true 0PARAMETER VALUE con_id------------------------------------------------------------ ------------------------------Database Resource Manager TRUE 0Spatial TR UE 0Automatic Storage Management FALSE 0Export Transportable tabl Espaces true 0Transparent application Failover true 0fast-start Fault Recovery true 0Sample Scan true 0Duplexed back    UPS TRUE                      0Java true 0OLAP Window Functions True                        0Block Media Recovery TRUE 0PARAMETER VALUE con_id------------------------------------------------------------------------------------------fine-gr Ained Auditing true 0Application Role true 0Enter Prise User Security true 0Oracle Data Guard true 0Ora  CLE Label Security FALSE 0OLAP TRUE 0Basic Compression true 0Join index true 0Trial Recov ery true 0Advanced Analytics true 0Online redefi    Nition TRUE                      0PARAMETER VALUE con_id--------------------------------------- ---------------------------------------------------Streams Capture TRUE 0File Mapp ing true 0Block change Tracking TRUE 0Flashba CK Table true 0Flashback Database true 0Transpare NT Data Encryption True 0Backup encryption True 0Unused Block Compression TRUE 0Oracle Database Vault FALSE 0R Esult Cache true 0SQL Plan Management true 0PAR Ameter 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 FA                         LSE 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 0P Arameter 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.

V$option && dba_registry