Oracle 组件 系列 小结

leonheart

　　

本文整理自网络，原文地址：http://blog.csdn.net/tianlesoftware/article/details/7339998#t3
　　

Oracle 组件的信息可以通过v$option 和 dba_registry 查看：
 
--查看v$option:

V$OPTION displaysOracle Database options and features. Typically,> 
SQL> select * from v$option;
 
PARAMETER                                VALUE
------------------------------------------------------
Partitioning                             TRUE
Objects                                  TRUE
Real Application Clusters                FALSE
Advanced replication                     TRUE
Bit-mapped indexes                       TRUE
Connection multiplexing                  TRUE
Connection pooling                       TRUE
Database queuing                         TRUE
Incremental backup and recovery          TRUE
Instead-of triggers                      TRUE
Parallel backup and recovery             TRUE
 
PARAMETER                                VALUE
------------------------------------------------------
Parallel execution                       TRUE
Parallel load                            TRUE
Point-in-time tablespace recovery        TRUE
Fine-grained access control              TRUE
Proxy authentication/authorization       TRUE
Change Data Capture                      TRUE
Plan Stability                           TRUE
Online Index Build                       TRUE
Coalesce Index                           TRUE
Managed Standby                          TRUE
Materialized view rewrite                TRUE
 
PARAMETER                                VALUE
------------------------------------------------------
Materialized view warehouse refresh      TRUE
Database resource manager                TRUE
Spatial                                  TRUE
Automatic Storage Management             FALSE
Export transportable tablespaces         TRUE
Transparent Application Failover         TRUE
Fast-Start Fault Recovery                TRUE
Sample Scan                              TRUE
Duplexed backups                         TRUE
Java                                     TRUE
OLAP Window Functions                    TRUE
 
PARAMETER                                VALUE
------------------------------------------------------
Block Media Recovery                     TRUE
Fine-grained Auditing                    TRUE
Application Role                         TRUE
Enterprise User Security                 TRUE
Oracle Data Guard                        TRUE
Oracle Label Security                    FALSE
OLAP                                     TRUE
Basic Compression                        TRUE
Join index                               TRUE
Trial Recovery                           TRUE
Data Mining                              TRUE
 
PARAMETER                                VALUE
------------------------------------------------------
Online Redefinition                      TRUE
Streams Capture                          TRUE
File Mapping                             TRUE
Block Change Tracking                    TRUE
Flashback Table                          TRUE
Flashback Database                       TRUE
Transparent Data Encryption              TRUE
Backup Encryption                        TRUE
Unused Block Compression                 TRUE
Oracle Database Vault                    FALSE
Result Cache                             TRUE
 
PARAMETER                                VALUE
------------------------------------------------------
SQL Plan Management                      TRUE
SecureFiles Encryption                   TRUE
Real Application Testing                 TRUE
Flashback Data Archive                   TRUE
DICOM                                    TRUE
Active Data Guard                        TRUE
Server Flash Cache                       TRUE
Advanced Compression                     TRUE
XStream                                  TRUE
Deferred Segment Creation                TRUE
 
65 rows selected.
 
SQL>
 
--查看dba_registry:
SQL> select comp_id,comp_name fromdba_registry;
 
COMP_ID         COMP_NAME
-------------------------------------------------
OWB             OWB
APEX            Oracle Application Express
EM              Oracle Enterprise Manager
AMD             OLAP Catalog
SDO             Spatial
ORDIM           Oracle Multimedia
XDB             Oracle XML Database
CONTEXT         Oracle Text
EXF             Oracle Expression Filter
RUL             Oracle Rules Manager
OWM             Oracle Workspace Manager
 
COMP_ID         COMP_NAME
--------------- ----------------------------------
CATALOG         Oracle Database Catalog Views
CATPROC         Oracle Database Packages and Types
JAVAVM          JServer JAVA Virtual Machine
XML             Oracle XDK
CATJAVA         Oracle Database Java Packages
APS             OLAP Analytic Workspace
XOQ             Oracle OLAP API
 
18 rows selected.
 
 
对于这些组件，MOS 有文章说明：
Oracle 8i/9i/10g/11g 组件（Components） 说明
http://blog.csdn.net/tianlesoftware/article/details/5937382
 
小整理了部分组件的重建，链接如下：
 
Oracle 9i 升级后 OLAP Catalog 组件 Invalid
http://blog.csdn.net/tianlesoftware/article/details/5937372
 
Oracle OLAP 组件重建 说明
http://blog.csdn.net/tianlesoftware/article/details/7321333
 
Oracle XDB 组件重建 说明
http://blog.csdn.net/tianlesoftware/article/details/7323139
 
 
Oracle ORA-31000: Resource'http://xmlns.oracle.com/xdb/acl.xsd' is not an XDB schema 解决方法
http://blog.csdn.net/tianlesoftware/article/details/7323193
 

Oracle JAVAVM 组件>http://blog.csdn.net/tianlesoftware/article/details/7334414
 
Oracle Spatial 组件 说明
http://blog.csdn.net/tianlesoftware/article/details/7334440
 
 
Oracle Text 组件 说明
http://blog.csdn.net/tianlesoftware/article/details/7334639
 
Oracle DataMining 组件 说明
http://blog.csdn.net/tianlesoftware/article/details/7336775
 
Oracle XDK 组件 说明
http://blog.csdn.net/tianlesoftware/article/details/7337205
 
OracleWorkspace Manager 组件 说明
http://blog.csdn.net/tianlesoftware/article/details/7339652
 
Oracle RulesManager 和Oracle Expression Filter 组件 说明
http://blog.csdn.net/tianlesoftware/article/details/7339939
 
OracleEnterprise Manager 组件 说明
http://blog.csdn.net/tianlesoftware/article/details/7339962
 
 
不同的组件对应不同的用户，具体关系如下表：
 

　　
OUTLN : Theaccount that supports plan stability. Plan stability prevents certain databaseenvironment changes from affecting the performance characteristics ofapplications by preserving execution plans in stored outlines. OUTLN actsas a role to centrally manage metadata associated with stored outlines.