Oracle 组件系列小结

来源：互联网发布：淘宝退款对买家的影响编辑：程序博客网时间：2024/04/25 20:02

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

--查看v$option:

V$OPTION displaysOracle Database options and features. Typically, although not always, optionsmust be separately licensed, whereas features come with the product and areenabled based on the product that is running (Standard Edition, EnterpriseEdition, and so on).

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 组件 Reload 说明

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.

-------------------------------------------------------------------------------------------------------

Skype: tianlesoftware

Email: tianlesoftware@gmail.com

Blog: http://www.tianlesoftware.com

Weibo: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

0 0

Oracle 组件 系列 小结

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

--查看v$option:

--查看dba_registry:

不同的组件对应不同的用户，具体关系如下表：

Oracle 组件系列小结