温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

v$option && dba_registry

发布时间:2020-07-22 17:04:18 来源:网络 阅读:504 作者:roidba 栏目:关系型数据库

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

--查看系统中的组件
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.
向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI