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               1
CATPROC                Oracle Database Packages and Types         VALID               1
JAVAVM                 JServer JAVA Virtual Machine           VALID               1
XML                Oracle XDK                     VALID               1
CATJAVA                Oracle Database Java Packages              VALID               1
APS                OLAP Analytic Workspace                VALID               1
RAC                Oracle Real Application Clusters           OPTION OFF              1
XDB                Oracle XML Database                VALID               1
OWM                Oracle Workspace Manager               VALID               1
CONTEXT                Oracle Text                    VALID               1
ORDIM                  Oracle Multimedia                  VALID               1

COMP_ID                COMP_NAME                      STATUS             CON_ID
------------------------------ -------------------------------------------------- ---------------------- ----------
SDO                Spatial                        VALID               1
XOQ                Oracle OLAP API                    VALID               1
APEX                   Oracle Application Express             VALID               1

14 rows selected.

--显示数据库选项和特性
SQL> col parameter for a40
SQL> col value for a40
SQL> select * from v$option;

PARAMETER                VALUE                        CON_ID
---------------------------------------- ---------------------------------------- ----------
Partitioning                 TRUE                          0
Objects                  TRUE                          0
Real Application Clusters        FALSE                         0
Advanced replication             TRUE                          0
Bit-mapped indexes           TRUE                          0
Connection multiplexing          TRUE                          0
Connection pooling           TRUE                          0
Database queuing             TRUE                          0
Incremental backup and recovery      TRUE                          0
Instead-of triggers          TRUE                          0
Parallel backup and recovery         TRUE                          0

PARAMETER                VALUE                        CON_ID
---------------------------------------- ---------------------------------------- ----------
Parallel execution           TRUE                          0
Parallel load                TRUE                          0
Point-in-time tablespace recovery    TRUE                          0
Fine-grained access control      TRUE                          0
Proxy authentication/authorization   TRUE                          0
Change Data Capture          TRUE                          0
Plan Stability               TRUE                          0
Online Index Build           TRUE                          0
Coalesce Index               TRUE                          0
Managed Standby              TRUE                          0
Materialized view rewrite        TRUE                          0

PARAMETER                VALUE                        CON_ID
---------------------------------------- ---------------------------------------- ----------
Database resource manager        TRUE                          0
Spatial                  TRUE                          0
Automatic Storage Management         FALSE                         0
Export transportable tablespaces     TRUE                          0
Transparent Application Failover     TRUE                          0
Fast-Start Fault Recovery        TRUE                          0
Sample Scan              TRUE                          0
Duplexed backups             TRUE                          0
Java                     TRUE                          0
OLAP Window Functions            TRUE                          0
Block Media Recovery             TRUE                          0

PARAMETER                VALUE                        CON_ID
---------------------------------------- ---------------------------------------- ----------
Fine-grained Auditing            TRUE                          0
Application Role             TRUE                          0
Enterprise User Security         TRUE                          0
Oracle Data Guard            TRUE                          0
Oracle Label Security            FALSE                         0
OLAP                     TRUE                          0
Basic Compression            TRUE                          0
Join index               TRUE                          0
Trial Recovery               TRUE                          0
Advanced Analytics           TRUE                          0
Online Redefinition          TRUE                          0

PARAMETER                VALUE                        CON_ID
---------------------------------------- ---------------------------------------- ----------
Streams Capture              TRUE                          0
File Mapping                 TRUE                          0
Block Change Tracking            TRUE                          0
Flashback Table              TRUE                          0
Flashback Database           TRUE                          0
Transparent Data Encryption      TRUE                          0
Backup Encryption            TRUE                          0
Unused Block Compression         TRUE                          0
Oracle Database Vault            FALSE                         0
Result Cache                 TRUE                          0
SQL Plan Management          TRUE                          0

PARAMETER                VALUE                        CON_ID
---------------------------------------- ---------------------------------------- ----------
SecureFiles Encryption           TRUE                          0
Real Application Testing         TRUE                          0
Flashback Data Archive           TRUE                          0
DICOM                    TRUE                          0
Active Data Guard            TRUE                          0
Server Flash Cache           TRUE                          0
Advanced Compression             TRUE                          0
XStream                  TRUE                          0
Deferred Segment Creation        TRUE                          0
Unified Auditing             FALSE                         0
Management Database          FALSE                         0

PARAMETER                VALUE                        CON_ID
---------------------------------------- ---------------------------------------- ----------
I/O Server               FALSE                         0
ASM Proxy Instance           FALSE                         0
Exadata Discovery            TRUE                          0
Data Mining              TRUE                          0
Global Data Services             TRUE                          0
Adaptive Execution Plans         TRUE                          0
Table Clustering             TRUE                          0
Zone Maps                TRUE                          0
Real Application Security        TRUE                          0
Privilege Analysis           TRUE                          0
Data Redaction               TRUE                          0

PARAMETER                VALUE                        CON_ID
---------------------------------------- ---------------------------------------- ----------
Cross Transportable Backups      TRUE                          0
Cache Fusion Lock Accelerator        TRUE                          0
Snapshot time recovery           TRUE                          0
Heat Map                 TRUE                          0
Automatic Data Optimization      TRUE                          0
Transparent Sensitive Data Protection    TRUE                          0
In-Memory Column Store           TRUE                          0
Advanced Index Compression       TRUE                          0
In-Memory Aggregation            TRUE                          0

86 rows selected.

分享标题:v$option&&dba_registry
URL标题:http://scyanting.com/article/ghspgc.html